Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI Masterclass Calculation Groups with Tabular Editor
Rating: 4.7 out of 5(47 ratings)
281 students

Power BI Masterclass Calculation Groups with Tabular Editor

Tabular Editor Calculation Groups in Power BI Desktop, Calculation Groups DAX Tabular Model, What are Calculation Groups
Created byDan We
Last updated 1/2026
English

What you'll learn

  • Understand what Calculation Groups are
  • How to work with Calculation Groups in Power BI Desktop
  • Learn and apply Tabular Editor Features in Power BI Desktop
  • Learn about the advantages of using Calculation Groups with Hands on Excercises
  • Learn to apply Best Practise Analyzer with Tabular Editor
  • Discover new job opportunities in a data driven future job market

Course content

2 sections • 24 lectures • 3h 18m total length

  • 1 Course Introduction1:12
  • Download section0:11
  • 3 Modelsetup Data load and Transformation with Powerquery Editor16:20
  • 4 What are Calculation Groups and why are they so useful9:47

    Calculation groups use scaffolds with a base measure and time intelligence functions (last year, last quarter, year-to-date) to generate multiple insights without duplicating measures, using Tabular Editor.

  • 5 Lets create our base measures11:21
  • 6 Dynamic Measure selection with switch statement10:25
  • 7 Introduction to Calculationgroups13:54

    Explore calculation groups in Power BI using Tabular Editor, create a calculation group, define calculation items with scaffolds like selected measure, deploy and refresh, apply to visuals.

  • 8 Why Calculationgroups are more then just measures9:51
  • 9 Formatting and sorting with Calculation Groups10:22

    Master formatting and sorting of calculation groups in Power BI with Tabular Editor, applying currency formats to base measures like total sales and total cost, and dragging to reorder items.

  • 10 Available Format options in Power BI3:52
  • 11 Benefits of Calculation Groups for Formatting Measures9:35
  • 12 Formatting with Calculation Groups6:10

    Apply calculation groups with tabular editor using a format string expression to format the selected measure. Display kg for total amount while keeping the default dollar format for other measures.

  • 13 Dynamic Formatting with Calculation Groups in Power BI10:12
  • 14 Summary 3 Ways to use Calculationgroups in Power BI5:20

    Explore three use cases for calculation groups in Power BI with tabular editor, using calculation items with switch statements, slicers, and filter panes to control time intelligence and visuals.

  • 15 Excourse Dynamic Currency Formating with Calculation Groups in Power BI19:21

    Explore dynamic currency formatting in Power BI with calculation groups and Tabular Editor. Learn to link currency codes and apply format strings based on the selected value.

  • 16 Introduction to Advanced Scripting with Tabular Editor13:12

    Discover advanced scripting in Tabular Editor, using useful snippets to create measures from selected columns and generate time intelligence measures for your model.

  • 17 Best Practice Rules in Power BI with Tabular Editor13:28
  • 18 Object Level Security A new way of security in Power BI11:26

    Explore object level security in Power BI with Tabular Editor to hide entire objects, such as the employees table, for specific roles while combining static and dynamic row-level security.

  • Power BI Trick Removing unused Measures5:18
  • Same Column Size Table Trick2:28
  • Power Query Tip and Update for Mac Users3:03
  • Create your own DAX functions in Power BI10:19
  • Congratulations, thanks a lot and one favor to ask0:21

Requirements

  • You already have some experience with Power BI (if not check out Power BI Masterclass - beginners to advanced first)
  • You should have worked with Power BI DAX and know how to create measures
  • Power BI Desktop installation (download for free on windows)
  • Tabular Editor 2 installation (download for free online)

Description

Microsoft Power BI Masterclass - The next level

Business Intelligence / Business Analytics is in high demand. Companies are constantly searching for ways to make better and faster and smarter decisions. Therefore they rely heavily on data. Small company or Multinational -  data driven decision making is the key to success for any business in the world of tomorrow.

Because of that companies are drastically increasing to step up their efforts to find skilled employees and freelancers with the necessary capabilities to help with analyzing data and creating valuable highly profitable insights. 

Since there is way more demand than supply it is a "War for talent". And the competition will increase further. This environment is a bless for anyone who acquires the necessary capabilities and positions herself/himself


MS Power BI is an advanced yet easy to get started self service business analytics / business intelligence solution provided by Microsoft which is currently in very hot demand. From my personal experience I can tell you that companies will actively searching for you if you master Power BI. Diving into data & analytics can not only immensely improve your career opportunities but also your job satisfaction!

Power BI is also a great tool for data science too. A lot of data scientists like to use it for visualizing and presenting the findings. Therefore learning to use this tool can also be a valuable skill for data science jobs.


ABOUT THIS COURSE:

This course should help you to enhance your skills as a Power BI Report developer.

We will learn HANDS ON

  • What is Tabular Editor and what are Calculation Groups

  • How to use Calculation Groups

  • What are the Advantages of Calculation Groups

  • Tabular Editors Best Practise Analyzer

  • Object Level Security in Power BI with Tabular Editor


Please note: The course is not meant for total beginners. I assume you have some prior knowledge with Power BI either from my other courses or otherwise acquired. If you are completely new then please check out the  beginners to advanced class first!


The other course of this series on Udemy


Update: The complete Power BI Masterclass Series on udemy (I have aggregated some classes together to provide more content value per class for you. I really hope that serves you better!

1. Power BI Masterclass - beginners to advanced

2. Microsoft Power BI Masterclass - Expand Excellence

3.Power BI Masterclass - DAX, Excel And More

4. The Power BI Masterclass - Additional Tips and Tricks

5. Power BI Desktop - Data Prep Challenges

6. Power BI Masterclass - DAX, R and Gateways

7. Power BI Masterclass - Python Finance and Advanced DAX

8. Power BI Masterclass - the next level

9. Power BI DAX Fundamentals Mastering the Key Concepts

10. Power BI Masterclass Calculation Groups with Tabular Editor

11. The Power BI Service Masterclass

12. How to build a profit and loss statement in Power BI Desktop


as well as from the Power Platform

Power Apps (Build your own Apps without coding. Also part of the Microsoft Power Platform)

  1. PowerApps for beginners build your own apps

RPA Microsoft Power Automate Desktop (Automate Desktop Applications like Microsoft Excel with drag and drop. No coding for beginners!

  1. Power Automate Desktop RPA for Beginners

We got a lot to do so let's get into it!

Who this course is for:

  • Power BI Developpers
  • Power BI Report Creators
  • Data Analysts
  • Business Users of Power BI Desktop
  • IT Departments
  • Data Scientists

Report abuse