Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PowerBI % difference measure

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 

Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    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.

9 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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 % 

       

       

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Icon for Super User rankSuper User
        5 years ago

        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.