Forum Discussion

kjani's avatar
kjani
Icon for Helper I rankHelper I
6 years ago
Solved

Help in building a template

I would like your help in building this in PowerBI Desktop. I have a dataset with multiple variables. I need to calculate difference in values based on scenario (e.g. 1_Base vs. 2_Low) for each Name ...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi kjani ,

     

    Check the code for the measure. It is subtracting the values and get the absolute value.

     

    Ricardo

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi kjani ,

 

You just need to drag a matrix visualization to show it:

 

Check this file: Download PBIX 

 

 

If you consider it as a solution, please mark as a solution and kudos.

Ricardo

  • kjani's avatar
    kjani
    Icon for Helper I rankHelper I
    6 years ago

    Thank you so much for quick response. However, I need the difference between the two scenarios. Your output is adding instead of subtracting. Thanks again.

    • camargos88's avatar
      camargos88
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Hi kjani ,

       

      Check the file again, I've updated it.

       

      Ricardo

      • kjani's avatar
        kjani
        Icon for Helper I rankHelper I
        6 years ago

        I am sorry, it's still adding the numbers. I need to see the difference in values between two scenarios (1_Base vs. 2_Low). Can you help? Thanks