The Power BI Blog for Professional Learning of the Microsoft Power BI, SQL Server, T-SQL, ETL and R Programming
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 Snapsh...
Popular Posts from this Blog
-
Microsoft Power BI Themes Colors with Hex Codes Reference -------------------------------------------------------------------------- List ...
-
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 extract FIRST NON BLANK and LAST NON BLANK values from a Column in Power BI The FIRSTNONBLANK() Function returns the first value in...
-
How to get the All Selected Values from a Slicer using SelectedValue, AllSelected, and ConcatenateX Functions in Power BI Scenario : Supp...
-
How to Execute a Stored Procedure with Parameters using a Function in Power Query Scenario: Lets say there is a Stored Procedure sp_SalesByP...
-
What is the difference between CALENDAR and CALENDARAUTO Functions in Power BI DAX CALENDAR Function (DAX) This function returns a table ...
-
How to remove or select Numbers or Text or Special Characters from a Alpha Numeric String using Power Query in Power BI Scenario: Suppose we...
-
How to Handle the Row yielded no match during lookup and Row disposition Errors in SSIS Lookup Transformation Scenario : Suppose we have ...
-
How to use DAX Studio to analyze Power BI Data Model Vertipaq Engine The VertiPaq Engine is the heart of Power BI Data Model. It is a sophis...
-
SQL Query to Calculate the Cumulative Sum or Running Total Scenario : Suppose we have a Table " TblSample " as follows.. ...