I need to merge table 1 and 2, Table 1 is unique table, Table 2 is many table, how can Table 1's data appear once without duplicate in each row? Thanks in advance!
Solved! Go to Solution.
Hi @RW0711 , It is simple by using merge option in the Power query editor.
Please check out the below link,
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hello, Thanks for your reply!
Yes, i have tried the merge option, but i dont want to duplicate Table 1 value in the merge table 3. As shown here, "SD document" from Table 2 has two rows, after merged, i wish to have only one row with "Advance value" from table 1. could you help out more? thanks!
Get a sneak peek into this year's Power Platform Conference Keynote.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!