Slowly Changing Dimension (SCD) in Power BI, Part 1, Introduction to SCD
Slowly changing dimension (SCD) is a data warehousing concept coined by the amazing Ralph Kimball. The SCD concept deals with…
Archive
Tag: Transformation
Combining X Number of Rows in Power Query for Power BI, Excel and Power Query Online
A while back, I was working on a project involving getting data from Excel files. The Excel files contain the…
Quick Tips: Conditionally Replace Values Based on Other Values in Power Query
Power Query (M) made a lot of data transformation activities much easier and value replacement is one of them. You…
Quick Tips: How to Filter a Column by another Column from a Different Query in Power Query
A while ago I was visiting a customer that asked if they can filter a query data by a column…