In this video, I show you how you can easily set up measures, like time intelligence ones for MTD, QTD and YTD, just once, and then reuse them on any measure without needing to recreate multiple versions, all using calculation groups in Tabular Editor 2, and also sort by any column too.
#powerbi #dax #measures #calculationgroups
🔗 Link to Tabular Editor
sqlbi.com/tools/tabular-editor/
▶️ Link to how to create the dashboard shown in this video
youtu.be/7lGjFs514f4
🔖c h a p t e r s 🔖
00:00 - Intro
00:30 - Get tabular editor
01:32 - Create a calculation group
02:19 - Create a calculation item
03:17 - Add your calculation item to a visual
04:34 - Add additional calculation items
06:06 - Explaining measures created
07:20 - View a different metric / measure
08:13 - Create a column sort filter
12:56 - Select only columns needed
13:11 - Use field parameter to select values
💌 My email - dean@deanchereden.com
🌍 My website - deanchereden.com
🐦 Twitter - twitter.com/deanchereden
🎵 Vhsceral - Gimetime chll.to/dd82e17f
🎶 Listen to Chillhop Music - youtu.be/kpO-nyGEBJ4
- Save HOURS by Reusing Multiple Measures in Calculation Groups | Power BI ( Download)
- CALCULATION GROUPS to REUSE & REDUCE MEASURES // Beginners Guide to Power BI in 2023 ( Download)
- Create REUSABLE measures using Calculation Groups in Power BI // Beginners Guide to Power BI ( Download)
- How To Bulk Copy Measures From Different Reports In Power BI ( Download)
- Learn how precedence setting in calculation groups help in interaction between visuals - Power BI ( Download)
- Limiting the number of calculation items selected - Unplugged #26 ( Download)
- Reduce the Amount of Measures You Write w/ DAX Calculation Groups | Power BI DAX Tutorial ( Download)
- Dynamic Power BI Report with Calculation Groups - Intro To Problem Of The Week #7 ( Download)
- Measures vs. calculated columns in DAX and Power BI ( Download)
- Using Multiple Calculation Groups Together in Power BI ( Download)
- NEW! Model Explorer and Calculations Groups in Power BI | MiTutorials ( Download)
- Calculation Groups in Power BI | Power BI Tutorial (54) ( Download)
- Using calculation groups in DAX ( Download)
- Add measures in bulk to your Power BI file without external tools ( Download)
- Build Multi KPI Comparator using Calculation Groups (Power BI DAX Tutorial) ( Download)