Calculation Group – Blog about Actionable Reporting

My Power BI Toolbox: 80+ Tabular Editor Macros to Automate Data Model Development

When it comes to streamlining your Power BI data modeling, the value of automation cannot be overstated. One of the most powerful tools available to achieve this automation is Tabular Editor, where you can write C# scripts to optimize and automate repetitive tasks. In this blog post, I’ll introduce you to my Power BI ToolboxContinue reading “My Power BI Toolbox: 80+ Tabular Editor Macros to Automate Data Model Development”

Spot Poor Power BI Reports: No3. No Units Calculation Group

When working with large datasets in Power BI, displaying big numbers—especially those over a million—can become a challenge. Lengthy figures not only clutter your visuals but can also confuse your audience. To enhance readability and comprehension, it’s essential to format these numbers into thousands, millions, or even billions. While Power BI offers several methods toContinue reading “Spot Poor Power BI Reports: No3. No Units Calculation Group”

Power BI – Pimp – Script

Do you would like to apply data model best practices with a click of a button to your existing Power BI reports? Than the “PBI-Pimp-Script” is the right place for you! Edit: This script had a major revamp, published on 31. January 2024 and includes now a lot more: Explicit Measure Creation, Units calc group,Continue reading “Power BI – Pimp – Script”