Forum Discussion
Difference in values from the same column in the same table based on
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
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 meausreI hope It may resolves your issue!
3 Replies
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 meausreI hope It may resolves your issue!
