Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
@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
Hi @JihyeHeo ,
Try the merge option in Power Query.
https://www.youtube.com/watch?v=M_jIsnksv7I
https://www.youtube.com/watch?v=CW-Er8slv9k
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Regards,
Harsh Nathani
User | Count |
---|---|
56 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |