Forum Discussion
Most efficient way to combine tables
Hello,
I'm looking to create a list/table that combines a couple fields from three existing tables, and creates a full list of those details, without duplicates. For example, we'd want to join Table A, B and C to create Table D (see below). What is the most efficient way to do this in PowerBi?
Thanks!
let Source = Table.Combine({Table_A, Table_B, Table_C}), #"Doublons supprimés" = Table.Distinct(Source) in #"Doublons supprimés"
2 Replies
EinomiHelper V
If you the tables you want to append (combine) have the same headers, then you can use the Append table feature
Then select all your new table and you can easily remove duplicates
Give it a try and if you need more help, I'll be happy to help more
- Einomi
let Source = Table.Combine({Table_A, Table_B, Table_C}), #"Doublons supprimés" = Table.Distinct(Source) in #"Doublons supprimés"