cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gupta_diksha
Helper II
Helper II

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. 

Capture.PNG

 

Thanks in advance. 

 

Best Regards,

Diksha Gupta

1 ACCEPTED SOLUTION
selimovd
Community Champion
Community Champion

Hey @gupta_diksha ,

 

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
 

 

View solution in original post

5 REPLIES 5
FrankAT
Super User II
Super User II

Hi @gupta_diksha ,

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.

 

16-05-_2021_14-08-36.png

 

 

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)

Hi Frank,

 

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

 

Regards

selimovd
Community Champion
Community Champion

Hey @gupta_diksha ,

 

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
 

 

View solution in original post

Capture.PNG

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

 

Thank you

Hi , Thank you for replying.

 

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors