Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am playing about in Power BI and have become stuck I am trying to work out the variance in percentage between to numbers,
This is the formula i have found that works but need to right it as a measure or column which would be best.
First: work out the difference (increase) between the two numbers you are comparing.
Increase = New Number - Original Number
Then: divide the increase by the original number and multiply the answer by 100.
% increase = Increase ÷ Original Number × 100.
If your answer is a negative number then this is a percentage decrease.
First: work out the difference (decrease) between the two numbers you are comparing.
Decrease = Original Number - New Number
Then: divide the decrease by the original number and multiply the answer by 100.
% Decrease = Decrease ÷ Original Number × 100
If your answer is a negative number then this is a percentage increase.
If you wish to calculate the percentage increase or decrease of several numbers then we recommend using the first formula. Positive values indicate a percentage increase whereas negative values indicate percentage decrease.
how can this be done?
For your issue, you could use a IF function to check which one is larger, New Number or Original Number. The sample expression would like below.
Difference=IF(New Number >Original Number,New Number - Original Number,Original Number - New Number)
If this is not what you want, please provide us some sample data, and elaborate your requirement, so that we can make further analysis.
Regards,
Charlie Liao
@v-caliao-msftThanks for the reply, what I am after is getting the percentage variance.
of Hours input against Hours Against = my varience%
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |