Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |