Category: M Code
March 29, 2022
Working with Lists in Power Query – Let’s Count Words
M Code
June 11, 2019
How Can I get a Lookup Table from a Slowly Changing Dimension (SCD)?
DAX
April 2, 2019
Power Query (M)agic: Parameters for Dataflows!
Intermediate
February 26, 2019
PowerQuery(M)agic: Conditional Joins using Table.SelectRows()
M Code
November 3, 2018
Automated Testing With Power Query
M Code
August 2, 2018
Power Query (M)agic – Nested Calculations in Power Query – Finance Application
Beginner
July 24, 2018
Power Query (M)agic – Using Power Query to Transform and Combine Online StatsCan Data
Intermediate
June 26, 2018
PowerQuery (M)agic: Combine M Functions and Formulas In Custom Columns
Beginner
December 7, 2017
On the Right PATH() – A DAX/Power Query approach to working with parent/child hierarchies.
Common DAX Functions
November 14, 2017
Jittered Scatter Charts in Power BI via DAX and Power Query
DAX