Forum Discussion
calculatation the % difference
I create a table like this in Power Bi. How would I calculate the % difference from this table similar to the example? The information is found in four diff tables in the Power Bi model.
For example:
% Difference: (V1-V2)/[(V1+V2)/2]*100
1. (53-63)/[(53+63)/2]*100=10%
2. (63-53)/[63+53)/2]*100=17.24%
2 Replies
=(53-63)/((53+63)/2)*100 =-17.24
Anonymous , your math in your example doesn't work. What are you doing with the brackets?
