You make a great data model in Power BI. It has calculations that are essential to the business. So much so that you get requests to create multiple versions of those measures such as Month to Date, Quarter to Date, and Year to Date. With the multiple variations of each measure in the model it has increased the complexity.

One solution to this problem is Calculation Groups. Calculation Groups in Power BI allow you to separate out the MTD, YTD, and QTD logic and reuse the measures you already created. Calculation Groups’ primary goal is to make DAX code less complicated. It allows users to display the variations for each measure in a report.

We will cover how to create Calculation Groups in Power BI and cover best practices. After attending this session, you will know how to:
• Create calculation groups
• Use multiple Calculation Groups in the same model
• Employ best practices when using Calculation Groups