Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    AnonymousThanks for the idea!!