Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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"
)
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.
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
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"
)
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |