PowerBI % difference measure

[Anonymous]

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 

[Jihwan_Kim]

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.

[Anonymous]

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 % 

[Ashish_Mathur · Accepted 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.

[Anonymous]

This works! Thank you so much!

[Ashish_Mathur]

You are welcome.

[Jihwan_Kim]

Hi, @Anonymous 

please kindly try the below.

percentage =

DIVIDE( SUM(Tablename[Outbound Calls]) - SUM(Tablename[Total]),SUM(Tablename[Total]), BLANK())

if still does not work, please kindly share the sample pbix file, then I can try to look into it to come up with a desirable solution.

Thank you.

Jihwan Kim

If this post helps, then please consider accept it as the solution to help the other members find it more quickly.

[Anonymous]

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

[Jihwan_Kim]

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.

[Anonymous]

I have the result now. Thank you for your help