Forum Discussion

ChoiJunghoon's avatar
ChoiJunghoon
Icon for Helper III rankHelper III
6 years ago
Solved

[DAX] How to append Table A/B

I want to create "NewTable".  I am able to use only DAX code.    Could you help me....   
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi ChoiJunghoon ,

     

    You may create calculated table like DAX below.

     

    Table3 =

var _Table= EXCEPT(VALUES(Table2[Date]),VALUES(Table1[Date]))

return

UNION(SUMMARIZE(Table1,Table1[Date],"Value", SUM(Table1[Value])),

SUMMARIZE(_Table, [Date],"Value", SUM(Table2[Value])) )

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

In the Query Editor, append the two tables.  To your visual, drag the Date column from the appended dataset and write this measure

=SUM(Data[Value])

Hope this helps.

ChoiJunghoon's avatar
ChoiJunghoon
Icon for Helper III rankHelper III
6 years ago

Sorry, I have to use only DAX function. 

Because, I use the Direct Query. 
and I've already done this report.