DAX

Power BI
4 de junio de 2021

Sorting a Parent-child defined Hierarchy

This is one problem that you don't realize it's a problem until you face it. Happened to me designing a P&L report. For this report, an arbitrary list of items (arbitrary to me of course) has to be displayed in certain order, each with it's own arbitrary calculation, and even with some hierarchy...
Leer post →
Power BI
11 de mayo de 2021

A truly dynamic tooltip

This post is based in a true use case. The customer followed the market share trends, to see how it compared to the rest, as a manufacturer, and at a brand level. So far so good. But coming from excel they were used to build charts any way they saw fit, so they liked to[...]
Leer post →
Power BI
24 de marzo de 2021

Using Calculation Groups in Calculated Tables

Calculated tables are not used often, because after all, it only combines data that you already have, right? Well, I didn't use them often, until recently. I was shown an excel chart displaying market share among top contenders, but including CY vs PY, then CYTD vs PYTD, then MAT vs MAT-1, and then ...
Leer post →