topic Re: Difference between 2 columns in different table in DAX Commands and Tips

Difference between 2 columns in different table

Anonymous — Fri, 28 Jun 2019 05:21:06 GMT

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 - Project name, estimated spent

Project name : abc, def, geh

estimated spent: 2000, 3000, 4000

Table B has columns - Project name, actual spent

Project name: abc, abc, def, geh, def, geh

actual spent: 500, 400, 500,1000,1000,1000

I want visula to show data as:

Project name: abc, def, geh

Difference : 1100,1500,2000.

Please help in making DAX for it.

Re: Difference between 2 columns in different table

Anonymous — Fri, 28 Jun 2019 08:56:24 GMT

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.

Re: Difference between 2 columns in different table

Anonymous — Fri, 28 Jun 2019 09:37:35 GMT

AnonymousThanks for the idea!!