Forum Discussion
new measure
How do I create a new measure within PowerBI for this calculation 100*((var1-var2)/var2)? Var1 and Var2 are amount fields within my table so I want to create the variance measure for use in charts and reports.
Without any idea about how your data is organized...
Try something like this
Measure = 100 * DIVIDE ( SUM( Table[Column1] ) - SUM ( Table[Column2] ), SUM ( Table[Column2] ), 0 )
If this doesn't work you'll have to provide more details.
Good Luck!
DUPLICATE POST
http://community.powerbi.com/t5/Desktop/New-Measure/m-p/120884
4 Replies
SeanCommunity Champion
Without any idea about how your data is organized...
Try something like this
Measure = 100 * DIVIDE ( SUM( Table[Column1] ) - SUM ( Table[Column2] ), SUM ( Table[Column2] ), 0 )
If this doesn't work you'll have to provide more details.
Good Luck!
DUPLICATE POST
http://community.powerbi.com/t5/Desktop/New-Measure/m-p/120884
Thank you that worked!
How do I create a new measure within PowerBI for this calculation 100*((var1-var2)/var2)? Var1 and Var2 are amount fields with my table. I just want to create a variance calculation measure using these fields so it can be used for my charts and reports.
- Sean
