Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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%
=(53-63)/((53+63)/2)*100 =-17.24
@Anonymous , your math in your example doesn't work. What are you doing with the brackets?
Proud to be a Super User!
It would be -14%. I'm trying to create a formula that would calculation the % difference within the Power Bi.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |