Forum Discussion
Solved
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 a...
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
Sean
Community Champion
Community ChampionWithout 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!