Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to Solution.
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26Rhi5W4P4FI9uuhZ9D?e=b75CeS
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26Rhi5W4P4FI9uuhZ9D?e=b75CeS
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