Merging Tables - Power Query Editor Tips and Tricks

[@furkansimsek33]

Thank you for sharing, great tips :)

[@rulec3949]

Ohh this is really nice. To solve the duplication I used a Nested Add Custom Columns (X let in +Add Custom Column + New Custom Column .... Each one with a combination of List.Distinct + Text.Combine). This is def. more user friendly.

[@juwayable]

Thank for yr cool, short & informative vid on this topic. Just what I needed.

[@محمدشاجعالشميري]

can you add image personality in the powerbi as slicers ?

[@peterfj6218]

Great tips!

[@oscarDelgado-v6y]

Muchas Gracias

[@pthapa55]

Can't you just remove the duplicates from Customer Lookup table in the email field before you merge them. That would solve the issue you are trying to solve. As we know in a lookup table, we shouldn't have duplicates, is that correct?

[@decentmendreams]

Thanks Mitch. I have done hundreds merges and never observed that. Did you try it on a relatively large data by any chance? I tried it and it was very slow when I tried to expand the table .

[@angieigles5832]

Hi, exactly the same happened to me, not only it is quite slow when expanding the table, it just slow down the whole file :(

[@Rahmankhan-ff8qh]

Can you Please explain how do you merge the tables of sem1 AND sem2

[@dereklowry3111]

Excellent

[@Nalaka-Wanniarachchi]

Nice trick..

[@PragmaticWorks]

Thanks!