Power BI DAX

Thumbnail

Evaluation context simply explained.

Together with the Power BI user group, I organized a Power BI DAX evening. We were hosted by GoDataDriven, where I was one of the two speakers.
Thumbnail

DAX for a calendar table

Most Power BI models require a date table. Just add a new table to your model and copy-paste this code to get one.
Thumbnail dateadd

Power BI DAX: DATEADD vs. PREVIOUSMONTH

Since I get questions from my clients about this topic, I decided to dedicate a blog to it. What is the difference between DATEADD and PREVIOUSMONTH? Isn't the result the same? The answer is that sometimes it is, but certainly not always. In this scenario, the result at the monthly level is the same Here's [...]
Thumbnail

Understand Filter Context in DAX in 5 minutes

You can't really use Power BI without being able to write DAX. And you shouldn't write DAX if you don't understand Filter Context. This video explains the concept in 5 minutes.
Thumbnail

Understanding Row Context in DAX in 5 Minutes

If you want to be able to write DAX, you will need to understand Row Context. Learn all about it in 5 minutes!