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)?

April 2, 2019

Power Query (M)agic: Parameters for Dataflows!

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

July 24, 2018

Power Query (M)agic – Using Power Query to Transform and Combine Online StatsCan Data

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
November 14, 2017

Jittered Scatter Charts in Power BI via DAX and Power Query