Forum Discussion
Difference between 2 columns in different table
Hello everyone, I am facing issue in creating DAX for difference between 2 columns in different tables. Table A and B has One to many relationship respectively. Table A has columns - Proj...
Hi there.
-- measure 1 in table A [Estimated Spend] := SUM( TableA[estimated spend] ) -- measure 2 in table B [Actual Spend] := SUM( TableB[actual spend] ) -- measure 3 in table B [Estimated - Actual] := [Estimated Spend] - [Actual Spend] -- TableB should be hidden and slicing should -- happen by the attributes of TableA.
Hi there.
-- measure 1 in table A [Estimated Spend] := SUM( TableA[estimated spend] ) -- measure 2 in table B [Actual Spend] := SUM( TableB[actual spend] ) -- measure 3 in table B [Estimated - Actual] := [Estimated Spend] - [Actual Spend] -- TableB should be hidden and slicing should -- happen by the attributes of TableA.
AnonymousThanks for the idea!!