How to combine three columns from different tables...

JihyeHeo · ‎08-19-2020

I have three columns from different tables and I want to combine them into one table.

Please refer to below.

I want to make a table ae below. The important point is that there are many rows wirh duplicate values in the Region and Province columns... Because of this, Merge won't give me the solution.

I already tried the merge and append fuction but I can't make the table I want. Please help!

amitchandak · ‎08-19-2020

@JihyeHeo , refer

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

https://www.youtube.com/watch?v=M_jIsnksv7I

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here