Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
53 | |
46 | |
15 | |
12 |