The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
82 | |
82 | |
35 | |
32 | |
32 |
User | Count |
---|---|
93 | |
79 | |
62 | |
54 | |
51 |