2022 Week 34 | Power BI: To Date Views and Dynamic Measures with Calculation Groups

NerdyWithData — Wed, 24 Aug 2022 02:15:20 GMT

Calculation Groups in Power BI essentially allow you to apply logic or formatting to a variety of measures at the same time. For example, let's say you were looking to create a Month-To-Date, Quarter-To-Date, and Year-To-Date view across Revenue, Orders, and Units. This would require you to create a calculation for each of the various date views... 9 measures in just this simple example! Imagine now that you want many more date views and many more measures. Calculation groups allow you to define each of the date views for whichever measure is being used in the Power BI view, providing a much simpler solution.

Calculation groups also allow you to apply other attributes to measures.

This week we're going to use calculation groups for Time Intelligence and Dynamic KPI Selection with Formatting.

https://www.workout-wednesday.com/pbi-2022-w34/

eyJrIjoiN2E3YzBkOGYtMWVhMy00N2JkLTgxNGYtNmExY2NiN2Q3YjcxIiwidCI6IjcxMjYwYjVhLTY3YTgtNDU3Yi05YzhjLThkNDM3ODgxOTgzMyIsImMiOjZ9&pageName=ReportSection

topic 2022 Week 34 | Power BI: To Date Views and Dynamic Measures with Calculation Groups in Data Stories Gallery

2022 Week 34 | Power BI: To Date Views and Dynamic Measures with Calculation Groups