Power BI

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
25 de mayo de 2025

Two new C# Scripts for PBIR: Replace Fields & Open Visual Json files

In comparison with my previous post, this one was an absolute breeze to write. Just an idea, some little tweaking with ChatGPT and GitHub CoPilot. Both come from the daily little miseries of daily with Power BI. One is replacing fields in a visual, the other one is finding the visual.json file of ce...
Leer post →
Power BI, Fabric
2 de marzo de 2025

Making a Report Bilingual: The full story (Part 2)

Hello again! Before life gets in the way, let's try to wrap this up. If you have not red the first part, please do so before reading this one as some of the outputs of that part are necessary for the process we'll see here. In this post I want to tackle the actual report.[...]
Leer post →
Power BI
14 de julio de 2024

Building a Referential Integrity Report Page with a C# Script

Hello again! I'm back with the other use case I have in mind for Report-layer scripts. If you haven't read yet my previous blog post I recommend you do this now as we'll be building on that with a more complex use case. When I first managed to develop C# in visual studio I rushed[...]
Leer post →
Power BI
12 de julio de 2024

C# Scripting the report layer with Tabular Editor

Hello! Today's post is quite special for me as I wished that this day would come. When I wrote the article to generate the measures for a dynamic data problems button there was a section that read "So, let’s build this button then. This part, unfortunately cannot be scripted, so we’ll need to work a...
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 →