Transcrito

Data Analysis Expressions (DAX) - Simply Explained

14 de jul. de 2026 · 15m 29s
Data Analysis Expressions (DAX) - Simply Explained
Descripción

Many Power BI users think DAX is just Excel formulas with a new name and then wonder why their numbers don't add up. This episode explains DAX in plain English...

mostra más
Many Power BI users think DAX is just Excel formulas with a new name and then wonder why their numbers don't add up. This episode explains DAX in plain English for Power BI beginners and analysts: measures versus calculated columns, filter context, CALCULATE, iterators, time intelligence and the pitfalls to avoid.

In this episode
  • 00:00 – What DAX really is
  • 01:55 – Calculated columns versus measures
  • 03:28 – The big idea: filter context
  • 05:02 – CALCULATE, the most important function
  • 07:11 – Iterator functions
  • 09:03 – Time intelligence made simple
  • 11:06 – Common beginner pitfalls
  • 13:09 – Putting it all together

Key takeaways
  • DAX works on whole tables and columns rather than cells, so treating it like Excel formulas leads to wrong results.
  • Prefer measures over calculated columns, because measures recalculate in the current filter context while columns stay static and bloat the model.
  • Master filter context and CALCULATE, use iterators only for row-by-row logic, and mark a proper date table so time intelligence works.

Worth quoting

“Here's the thing, most people think DAX is basically Excel formulas with a different name, but it isn't. DAX is a whole different way of thinking about calculations.” – Mirko Peters (00:10)

“If the number needs to change when someone clicks a button, use a measure. If it is the same no matter what, a calculated column is fine.” – Mirko Peters (02:49)

Explore more on M365.FM

Follow and rate M365.FM in your podcast app, and join the free M365 community at m365con.net.

Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.
mostra menos
Información
Autor Mirko Peters M365, Azure & AI
Organización m365 FM
Página web www.m365.fm
Etiquetas

Parece que no tienes ningún episodio activo

Echa un ojo al catálogo de Spreaker para descubrir nuevos contenidos.

Actual

Portada del podcast

Parece que no tienes ningún episodio en cola

Echa un ojo al catálogo de Spreaker para descubrir nuevos contenidos.

Siguiente

Portada del episodio Portada del episodio

Cuánto silencio hay aquí...

¡Es hora de descubrir nuevos episodios!

Descubre
Tu librería
Busca