The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 @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"
)
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)
Hi Frank,
Thank you for replying. How did you calculate value type column? Could you pls tell it?
Regards
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"
)
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?
User | Count |
---|---|
78 | |
77 | |
38 | |
31 | |
28 |
User | Count |
---|---|
106 | |
96 | |
55 | |
49 | |
46 |