Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to Solution.
let
Source = Table.Combine({Table_A, Table_B, Table_C}),
#"Doublons supprimés" = Table.Distinct(Source)
in
#"Doublons supprimés"
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
let
Source = Table.Combine({Table_A, Table_B, Table_C}),
#"Doublons supprimés" = Table.Distinct(Source)
in
#"Doublons supprimés"
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
39 | |
20 | |
20 | |
13 | |
13 |