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 ...
-
How to Identify the duplicate Values in a Column using Power Query Scenario: Suppose, we have a dataset( ds_Sample ) as below with duplicate...
-
Send Mail Task to Send Error Email with Error Code, Error Description in SSIS Scenario : Suppose we have an SSIS Package with some tasks....
-
Calculate YTD Sales and create a Line Chart to show Sales Trend using Power BI To show YTD Sales growth Momentum, first we need to Calculate...
-
SQL Arithmetic Overflow Error Converting Varchar to Data Type Numeric The Arithmetic Overflow Error occurs when converting a numeric or ...
-
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...
-
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 use Cursor in SQL to Consolidate Data from various Tables with different Structures Scenario: Suppose you are working in a pharmaceu...
-
How to Switch Source Query Connection Strings in Power BI with Dynamic Query Parameters Scenario: To manage multiple data or query environm...
-
How to use Value.Metadata function in Power Query to reference a Step from another Query In Power Query (M language), the meta keyword is u...