Calculation Groups & C#: Happily Ever After in Advanced Power BI

21/05/2025

Abstract

In the advanced session “Happily Ever After in Advanced Power BI,” we unravel the powerful alliance between Calculation Groups and C# scripting, a partnership that revolutionizes the creation and management of semantic models in Power BI. This workshop is designed to guide attendees through the process of harmonizing data model creation across their organization, providing a consistent, yet flexible foundation for Power BI users to build upon.

Dive into the heart of data modeling as we demonstrate how to leverage Calculation Groups alongside C# scripting to automate the standardization of semantic models. This approach not only ensures uniformity across all reports but also grants power users the agility to tackle complex reporting needs with ease and creativity.

Throughout this engaging session, we will meticulously craft a complete script from start to finish. This script will streamline the management of your semantic models by eliminating outdated measures, establishing vital Calculation Groups, and dynamically generating measures equipped with detailed descriptions and custom formatting. These steps are crucial in laying down a robust infrastructure that bolsters the efficiency and analytical capabilities of power users.

Speakers

Paulina Jędrzejewska

Power BI Consultant @ b.telligent

Paulina specializes in data modeling and automation in Power BI. She also has experience with data warehousing, SQL, and ETL.

“I got to know Power BI during my studies and it was love at first sight. I’m amazed how powerfull this tool is and that it is becoming better every month. As a consultant and trainer, I have the opportunity to inspire my clients and show them that Power BI is more than just colorful reports.”