The Power BI Blog for Professional Learning of the Microsoft Power BI, SQL Server, T-SQL, ETL, R Programming and Excel VBA Macros
Featured Post from this Blog
How to compare Current Snapshot Data with Previous Snapshot in Power BI
How to Dynamically compare two Snapshots Data in Power BI Scenario: Suppose, we have a sample Sales data, which is stored with Monthly Snaps...
Popular Posts from this Blog
-
Microsoft Power BI Themes Colors with Hex Codes Reference -------------------------------------------------------------------------- List...
-
SQL Query to Calculate the Cumulative Sum or Running Total Scenario : Suppose we have a Table " TblSample " as follows.. ...
-
How to use Commit, Rollback and SavePoint commands in SQL Server The Commit, Rollback and SavePoint are the Transactional Controlling Lang...
-
How to get the All Selected Values from a Slicer using SelectedValue, AllSelected, and ConcatenateX Functions in Power BI Scenario : Supp...
-
Removing a Carriage Return, Line Feed (CRLF) from a Column in SQL Server The term CRLF refers to Carriage Return (ASCII CHAR(13), \r) Li...
-
How to Dynamically Create an Excel File with Date Time from SQL Server Table using SSIS Package on each Execution Senario : Suppose I hav...
-
Matrix Indexing, Filtering and Resizing the Matrix in R Programming We can perform various operations on Matrices like Indexing (to access...
-
The Vectorized Operations in R Programming One of the most effective ways to achieve speed in R code is to use operations that are vectori...
-
How to Calculate Previous Weeks data based on Slicer Selection of Current Week in Power BI Scenario : Suppose we have a data Model as fol...
-
How to Add and Delete Vector Elements in R Programming Vectors are one-dimensional arrays that can hold numeric data, character data, or l...