Calculation Groups & C# - The Perfect Couple

on YouTube ↗38m

" summary

Demonstrates how C# scripting in Tabular Editor generates measures from KPI columns, loops through 20–60 base measures and five calculation items, and writes per-item measures into display folders with descriptions so authors see base measure + calculation. Uses Power BI Desktop, Visual Studio Code and Tabular Editor, calls Model.Tables.*, creates measures via model.AddMeasure, saves the model and the new measures appear in Power BI — automation works and enforces naming, folders and reuse.

AI-written summary · about

" chapters (15)

1. 0:00Introduction
2. 1:13Agenda and BI stages
3. 3:02Calculation groups and C# match
4. 5:13Showcase problem with groups
5. 7:25C# scripting in Power BI
6. 10:41Model setup and first script
7. 15:26Auto-creating measures with C#
8. 19:41Saving and verifying measures
9. 20:05Calculation groups basics
10. 23:15Defining items in Tabular Editor
11. 27:31Time intelligence items
12. 29:03Combining C# and groups
13. 29:44Automating measure creation
14. 34:30Adding measure descriptions
15. 36:59Summary and Q&A

" related talks

• 48mCombine Power BI with External ToolsMiguel Félix · SQLBits 2023
• 51mData modeling for experts with Power BIMarc Lelijveld, Jeroen ter Heerdt · SQLBits 2023
• 43mBecome a Power BI Data Modeling Wizard using Tabular Editor 3Morten Lønskov, David L. Bojsen · SQLBits 2023
• 01h 08mAdvanced Modelling and Calculation Using the Power BI DesignerKasper de Jonge · PASS Business Analytics Conference 2015
• 54mData Visualization with Power View and the Tabular ModelJen Stirrup · PASS Business Analytics Conference 2013
• 47mPower BI Meets Programmability – TOM, XMLA, and C#Kristyna Hughes · SQLBits 2023
• 20mRevolutionize reports with Fabric Copilot and Power BIAmber King · Microsoft Build 2024
• 01h 05mDynamic Presentation Using Excel CUBE FormulasBob Phillips · PASS Business Analytics Conference 2015