Adding two columns with unique data with DAX

PDiddy

New member
Joined
Feb 26, 2015
Messages
8
Reaction score
0
Points
0
Hi There,

Just looking for some help with the following:

TABLE 1
Order Cost
1600500 $500
1600600 $750

TABLE 2
Order Cost
1600500 $1000
1600600 $2000

I would like to sum the costs for each order to create a calculated column.

Thanks for the help.
 
I wouldn't bother with a Calculated Column, just add a measure (Calculated Field) like so

=CALCULATE(SUM(Table1[Cost]) + SUM(Table2[Cost]))
 
Back
Top