PDA

View Full Version : Adding two columns with unique data with DAX



PDiddy
2015-02-26, 06:27 PM
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.

Herbds7
2015-02-27, 02:38 AM
Excel 2010 with free PowerPivot and Power Query Add-In.
Compatible with Office 2013 Pro Plus.
Easier with Measure instead of Calculated Column.
With "Paste Append" in Power Pivot.
With "Append Query" and "Group Column" in Power Query.
http://www.mediafire.com/view/mmkfq9rsffag7rt/02_26_15a.xlsx
Share your file if it is more complicated.

Bob Phillips
2015-02-27, 09:54 AM
I wouldn't bother with a Calculated Column, just add a measure (Calculated Field) like so

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