C# Script

Power BI
13 de noviembre de 2022

How to write a C# script for Tabular Editor (part 2): In-Script Classes

Well, hello again. If you just got started with Tabular Editor scrips and programming in general, maybe today's topic might be a bit too much, but if you either familiar with other programming or already know your way in c# scripts, then this will certainly become a valuable thing: in-script classes...
Leer post →
Power BI
31 de octubre de 2022

How to write a C# script for Tabular Editor (part 1)

Well, well, this is another article about C# Scripts. A topic that deserves much more attention than it's getting. If you haven't read my previous post, go do it right now because otherwise writing a c# script is a very frustrating experience. Not as much as building a Data Factory pipeline as a new...
Leer post →
Power BI
8 de octubre de 2022

Writing Tabular Editor C# Scripts like a Boss

A few months back I wrote an article of what I thought would change the way I (and many more I thought) would write c# scripts from now on. In that article I explored the possiblity of creating a custom dll with all the classes and methods that would make my scripts shorter, more robust[...]
Leer post →
Power BI
17 de septiembre de 2022

A dynamic legend for a dynamic measure + time intel chart

Well it's no secret that I like calc groups. But it's also true that calc groups have an achiles heel. Calc Item names are constant, so for charts, legends stay the same no matter what. Depending on your use case you might get away with it, but sometimes you might get an end user that[...]
Leer post →
Power BI
14 de septiembre de 2022

Activating inactive relationships the smart way

Hi, today I want to talk about inactive relationships. Those relationships with the dashed line that unless you invoque them with USERELATIONSHIP they do nothing. The thing is a common pattern if you read this blog -- let's say you have a retail model, and for some charts you need to use the order d...
Leer post →
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
16 de marzo de 2022

Easy Management of Referential Integrity

Referential what? it sounds weird, but it's a rather basic thing: It's like asking, do you have all the product IDs of the sales table in your product table? If you don't, then is when that infamous "blank" appears in slicers and all kind of bad things start to happen. Unless you load everything fro...
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 →