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 31, 2018

Know When to Hold ‘Em – Part II. Time for DAX

Advanced July 24, 2018

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

Intermediate July 17, 2018

Know When to Hold ‘Em – Part I. Fun With Lists

Advanced June 26, 2018

PowerQuery (M)agic: Combine M Functions and Formulas In Custom Columns

Beginner