Category: M Code
June 11, 2019
How Can I get a Lookup Table from a Slowly Changing Dimension (SCD)?
April 2, 2019
Power Query (M)agic: Parameters for Dataflows!
February 26, 2019
PowerQuery(M)agic: Conditional Joins using Table.SelectRows()
November 3, 2018
Automated Testing With Power Query
August 2, 2018
Power Query (M)agic – Nested Calculations in Power Query – Finance Application
July 31, 2018
Know When to Hold ‘Em – Part II. Time for DAX
July 24, 2018
Power Query (M)agic – Using Power Query to Transform and Combine Online StatsCan Data
July 17, 2018
Know When to Hold ‘Em – Part I. Fun With Lists
June 26, 2018
PowerQuery (M)agic: Combine M Functions and Formulas In Custom Columns
December 7, 2017
On the Right PATH() – A DAX/Power Query approach to working with parent/child hierarchies.
Common DAX Functions