Forum Discussion

nhanser's avatar
nhanser
Regular Visitor
10 years ago
Solved

DAX to Union two sums

Hello,   I think that I may be overthinking how to do this in DAX, but any help would be musch appreicated.  What I am looking to do is combine two diffrent set of data into one table in dax.   F...
Need Help
  • TaylorClark's avatar
    TaylorClark
    10 years ago

    Try some calculated tables!

     

    In Data View, choose New Table then

     

    UnionedTable = UNION(TableA, TableB)

     

    Then use it to create another calculated table

     

    SummaryTable = SUMMARIZE(UnionedTable, [group], [sub-group], "Qty", SUM(UnionedTable[qty]))

     

    Hope this helps!

TaylorClark's avatar
TaylorClark
Icon for Power BI Team rankPower BI Team
10 years ago

Try some calculated tables!

 

In Data View, choose New Table then

 

UnionedTable = UNION(TableA, TableB)

 

Then use it to create another calculated table

 

SummaryTable = SUMMARIZE(UnionedTable, [group], [sub-group], "Qty", SUM(UnionedTable[qty]))

 

Hope this helps!