Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
I have data stored in a table called "Data", i need to calculate the difference on a column called "Amount (GC)" based on another column called Source, the data in Source could either be METS or TMS in the source column.
So as an example the difference here would be = (METS)9 990 658.3 - (TMS)6 834 819 = 3 155 839
Solved! Go to Solution.
Hi @Mansoer09
You need to create seperate measures for METS and TMS and do the minus operation
or create this dax under single measure
Final =
var METS GC= calculate( sum(amount), Source= "METS")
var TMS= calculate (Sum(amount), Source= "TMS")
var Difference = [METS GC] - [TMS]
Return Difference
Or create seperate measure for individual calculation
1) METS measure
2)TMS measure
3) Diff meausre
I hope It may resolves your issue!
Hi @Mansoer09
You need to create seperate measures for METS and TMS and do the minus operation
or create this dax under single measure
Final =
var METS GC= calculate( sum(amount), Source= "METS")
var TMS= calculate (Sum(amount), Source= "TMS")
var Difference = [METS GC] - [TMS]
Return Difference
Or create seperate measure for individual calculation
1) METS measure
2)TMS measure
3) Diff meausre
I hope It may resolves your issue!
Thanks Uzi, will give it a go
Hi @Mansoer09
If my post/solution helps you. You can Accept as solution so other may find it quickly.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |