Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to calculate difference between two rows in a table?

Hi everyone,

 

I need your help. I want to calculate the difference of Montant of C and D. Supposingly, I would like to subtract montant of C from montant of D. I want to display Difference i.e- 0.10  instead of total value displayed in third row. 

 

Thanks in advance. 

 

Best Regards,

Diksha Gupta

Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    you can subtract one from the other:

    Difference Montant C to D =
CALCULATE(
    SUM( myTable[Montant] ),
    myTable[Sens] = "D"
)
- CALCULATE(
    SUM( myTable[Montant] ),
    myTable[Sens] = "C"
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

5 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    you can subtract one from the other:

    Difference Montant C to D =
CALCULATE(
    SUM( myTable[Montant] ),
    myTable[Sens] = "D"
)
- CALCULATE(
    SUM( myTable[Montant] ),
    myTable[Sens] = "C"
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi , Thank you for replying.

       

      The formula suggested by you is not working fine. Could you please suggest something else instead?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hey It worked but why is It 0.13 instead of 0.10?

       

      Thank you

  • FrankAT's avatar
    FrankAT
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi Anonymous ,

    Your two numbers exceed the computational accuracy of Power BI Desktop. I have therefore shortened it a little and added a calculated column for calculation.

     

     

     

    Subtract = 
IF (
    HASONEVALUE ( 'Table'[Sens Montant] ),
    MIN ( 'Table'[Value] ),
    SUMX ( 'Table', 'Table'[Value] * 'Table'[Value Type] )
)

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Frank,

       

      Thank you for replying. How did you calculate value type column? Could you pls tell it?

       

      Regards