Constant value in a column for each table in DAX UNION

[Anonymous]

Hi All,

I'm still learning Power BI DAX and coudn't find a good example in the forum as per my requirement.

I have two tables TABLE_A and TABLE_B, I need to UNION these two tables and add a new column with constant value to the result to indicate the row belogs to which table.

Example below with expected output and more important is to have the same column headers like "Source", "TSID", "Product" and "Location".

Thanks

Sara

[Ahmedx · Accepted solution]

Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26Rhi5W4P4FI9uuhZ9D?e=b75CeS

[Anonymous]

Thanks @Ahmedx 

@AFrathanks for your suggestion, but I wanted to do only using DAX.

[AFra]

you can easily do it in on Power query : 

1. you add for each table a column named Source = TABLE A or B

2. append table B on table A