Results 1 to 3 of 3

Thread: Adding two columns with unique data with DAX

  1. #1

    Adding two columns with unique data with DAX



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    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/mmkfq9...02_26_15a.xlsx
    Share your file if it is more complicated.

  3. #3
    I wouldn't bother with a Calculated Column, just add a measure (Calculated Field) like so

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •