Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
209 | |
118 | |
116 | |
81 | |
74 |