DAX

Power BI
16 de septiembre de 2025

Automatically create measures with DAX user-defined functions

YES! Public preview is finally here, and DAX UDFs have the potential to change how we write DAX in a big way. If you don't know what UDFs are, head over to Microsoft (and SQLBI of course) and learn everything they have said about them first, no point in repeating it here. If you want[...]
Leer post →
Power BI
26 de mayo de 2024

Comparing arbitrary date ranges in Power BI

Hello there! Today's post comes from an actual requirement that I had heard before but never handled directly. There is some nifty DAX and modeling so lets get to it! (at the very end you will find a script to achieve the end result with no effort! but don't be greedy and read along to[...]
Leer post →
Power BI
1 de mayo de 2024

Showing the path of the selected point in a scatter chart

UPDATE: I was kindly asked by Kerry Kolosko to make a Work-Out-Wednesday challenge for this chart, and when I did, I realized that it's much more simple than I laid out on this article. I keep as proof that finding the best approach is an iterative process! Building the model from scratch also helps...
Leer post →
Power BI
1 de febrero de 2024

Reversing selection on a slicer (sort of)

Hello! The other day on the PUG Barcelona whatsapp group there was a question regarding the possibility of reversing the selection on a slicer, with a single click. Apparently this is something you can do on Qlik and the fellow member was trying to migrate that to Power BI as the users are used to[....
Leer post →
Power BI
6 de julio de 2023

The Calculation Group Paradox

Hello, today I'm not writing any type of tutorial. I just want to share a weird behavior I have found in calculation groups, hoping that those that really know about the inner workings can help us comprehend why they behave like that. Calculation groups can be seen as groups of pairs of DAX expressi...
Leer post →
Power BI
24 de junio de 2023

Sorting a matrix by a calculation item column

Hi! actually I was writing another blog post, but today I was shown something that can be done with calc groups that I wasn't aware of. And not only that, even though the blog post I was shown had some very clever thinking behind, I found there's still some room for improvement to bring the[...]
Leer post →
Power BI
17 de abril de 2023

Comparing snapshots by state

Hello hello, I'm not writing that much lately due to spring break and a DAX training I'm teaching, but I think I have just enough time to explain a fun use case I found the other day at work. In Real Estate each asset can be in a bunch of different states, especially if there[...]
Leer post →
Power BI
11 de febrero de 2023

The Ultimate Snapshot Report (part 3)

Hello there,  yes, a third part of the snapshot report and I'm not even sure it's the last one. The thing is that since the last post there has been some major improvements on the set up that I thought are worth sharing. In my previous post I ended up with a small defeat. There[...]
Leer post →
Power BI
10 de diciembre de 2022

The ultimate snapshot report (part 2)

Hello again. You didn't think there would be a second part, right? well, me neither. But as things turn out, I had to work on another report dealing with snapshots, and this time they wanted something fancier. It took me a while to figure it out, but I like the result so I thought it[...]
Leer post →