Forum Discussion
naseem_1973
Helper I
Helper IMultiple measures variance in Sigle table
Dear All, I want to create a dynamic table in Power BI like below. Is there any shortcut where I can take variance in multiple measures? Note: The example table is in Excel format. I have alre...
Thejeswar
Super User
Super UserHi naseem_1973 ,
Since you already have the measures in rows and the value gets split by Month, you should create a separate measure for Variance. You should also consider using Calculation Group to make this measure dynamic.
The Below is the link where you can read about Calculation Groups