Forum Discussion

Namratha's avatar
Namratha
Frequent Visitor
8 years ago
Solved

Calculating % between specific ROWS

Hi Everyone,   I'm finding it difficult to find the % between two specific rows. As shown in the sample data, I have Revenue and Total Operating Income and I want to see the running % (increase/de...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Do you want this?  Download the file from here.

     

Namratha's avatar
Namratha
Frequent Visitor
8 years ago

Thank you for the prompt reply!

 

Could you please guide me with the steps to do the above?

  • Namratha's avatar
    Namratha
    Frequent Visitor
    8 years ago

    Hello,

     

    My excel file has only two rows : Total Revenue and Total Operating Income

    - Desired result (i.e. Operating Income/Total Revenue) is the output I want to see in Powerbi as my result.

     

    Firstly I load my excel sheet in power bi and this how it looks like:

     

    - next while I go to my query editor this is how it appears:

    Could you please guide me with instructions after this step above?

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      Namratha

       

      I prepared this pbix file for you.

       

      Click here

       

      You can follow the steps from the APPLIED steps section

      • Namratha's avatar
        Namratha
        Frequent Visitor
        8 years ago

        Thank you I just got the fix I was missing....

         

        Can we do this by adding a measure - so that way I can use multiple measures to see % for multiple rows/different row combinations in my dataset?

         

        - my data is really huge and it is not only 2 standard comparisons that I require

         

        ex: income vs revenue

        expense vs revenue

        expense vs income etc...

         

         Also the calculated values should reflect in % format