Appending 2 Tables By using DAX

[suparnababu8]

Hi All..!!

I have two tables like 

Table A like below

and 

Table B like below

and

i will get Result Table as follows

Any one pls help inthis regard.

Thanks in Advance...
@Incom @com 

[Syk]

You can do this in power query quite easily. 

[NaveenGandhi · Accepted solution]

Hello @suparnababu8 

use the below Dax to create the table.

ResultTable =
SUMMARIZE (
UNION (
SELECTCOLUMNS ( 't1', "Month", 't1'[Month] ),
SELECTCOLUMNS ( 't2', "Month", 't2'[Month] )
),
[Month],
"Amt",
LOOKUPVALUE ( T2[Sales], T2[Month], [Month] )
+ LOOKUPVALUE ( T1[Sales], T1[Month], [Month] )
)

Let me know if this helps!

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!