Advanced Scripting

Power BI
12 de julio de 2022

Data Validation with Power BI

I know, I'm back again at validations, but this time is a bit different. Recently I've found myselft in a project where the data that was coming in was not fulfilling the sepcified requirements. We tend to thing that data that comes out of a system will always be pristine, but well, at least in[...]
Leer post →
Power BI
13 de junio de 2022

Creating well-formatted measures based on a calculation group

Calculation Groups biggest contribution is to help us reduce the number of measures that we have to create and manage. However, sometimes, me might want measures again... Of course we can forgo the calc group altogether, but we might want to keep the centralized logic while having actual measures, a...
Leer post →
Power BI
12 de febrero de 2022

One-click Calculation Groups for your toolbelt

Hello there, today I don't have any new fancy use case for calculation groups or anything else, but rather a repository of links to the best of the best c# scripts... to create calculation groups. The main use of this post is to point people this way when I do a presentation on calculation groups,[....
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
1 de mayo de 2021

Time intelligence -- the smart way

Ok, by now you probably know I'm a liiiiitle too much into calculation groups. Once you try calculation groups there's no going back. Particularly if you do time intelligence analysis (that is comparing values with the previous year, but many other things as well). The reason is that normally you wo...
Leer post →