Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |