Power BI: Understanding M

Enough to make you dangerous.

Dangerously cool. Photo by Samantha Hurley from Burst.

When starting out in Power BI, I struggled to understand the difference between M and DAX and measures vs. calculated columns (if you are in the same boat, this overview might help).

TL;DR: Power Query is what you use in Power BI to load in your dataset and clean and manipulate your data. M is the language used in Power Query. You with me…