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.
Hi,
I would like to ask what is the equivalent of getting a % difference of two numbers in PowerBI measure?
I am used to this on excel and would like to replicate it in PowerBI please.
(New Value - Old Value) / Old Value
Thank you
Solved! Go to Solution.
Hi,
Assuming Total and Outbound call are both measures in PBI Desktop, try this measure
Diff (%) = divide(([Outbound calls]-[Total]),[total])
Format this measure as %.
Hope this helps.
Hi, @Anonymous
I think it is the same.
Or, you please try the below.
percentage difference = divide ( new value - old value, old value, blank() )
Jihwan Kim
If this post helps, then please consider accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you, I have tried your suggestion and its just not bringing the correct %
Below is what I have in excel and I need the exact result in PowerBI, I have tried calculate and divide function. It brings result everytime but not the correct %
Hi,
Assuming Total and Outbound call are both measures in PBI Desktop, try this measure
Diff (%) = divide(([Outbound calls]-[Total]),[total])
Format this measure as %.
Hope this helps.
This works! Thank you so much!
You are welcome.
Hi, @Anonymous
please kindly try the below.
Jihwan Kim
If this post helps, then please consider accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Jihwan_Kim
Please see attahced a sample file. I tried and its just not giving me the correct %
I have added the % I require by calculating in excel in my sample file. Thank you so much
https://drive.google.com/file/d/18hjL14yjIEd32T0hNh0dDWFz622TrrIj/view?usp=sharing
Hi, @Anonymous
The link requires an access key.
Please check and let me know the public shared version.
Thank you.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
I have the result now. Thank you for your help
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
82 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
111 | |
110 | |
72 | |
71 |