Power BI

Power BI

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, Governance

Some SQL Server governance that can give huge results

This blog post is 90% SQL server and 10% Power BI, so if you are not into SQL Server (or relational databases in general) this might not apply to you. That being said, this blog post explains how to record the size of all tables in the server, and how to measure which tables are[...]
Leer post →
Power BI, Governance

A nice background always, with the minimum effort

Yep, today it's reporting. Lately I'm trying to give some shape to the governance of an organization, and well, reports having a unified look it's a good thing. At the very least for those supposed to be "Tier 1" or "The reports that really matter to top brass people". As with business logic, I'm al...
Leer post →
Power BI

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

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

Dynamic headers in Power BI, sort of.

Well, I was happy with the result, but I was even more happy with the reaction on twitter. The dynamic header effect felt like magical to many people, and well, I have many more followers now, thank you all. In case you haven't seen it, here's the video So how did I do it? Short[...]
Leer post →
Power BI

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 →
Power BI

The ultimate snapshot report

Lately I've been building a report, which had not happened for a while, and I enjoyed the process. The final result too is simple yet effective, so I thought I would share the approach here because, yes, there is a calc group in place that does some of the magic. This approach is valid when[...]
Leer post →
Power BI

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 →