Forum Discussion
Solved
Create new table from multiple tables
Hi, Having 4 similar tables as: What can I do to have a new table with Only unique Owners names? I'm creating it like this, but it doesnt show all users. let
Source =...
Hello
If my post helped you, please give me a 👍kudos and mark this post with Accept as Solution.
Do you mean that?let Source = Table.Combine({Email[[Owner]], Appointment[[Owner]], Lead[[Owner]], Opportunity[[Owner]]}), Duplicates = Table.Distinct(Source) in Duplicates
Best regards from Germany
Manuel Bolz
🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on Github
Hello
If my post helped you, please give me a 👍kudos and mark this post with Accept as Solution.
Do you mean that?
let
Source = Table.Combine({Email[[Owner]], Appointment[[Owner]], Lead[[Owner]], Opportunity[[Owner]]}),
Duplicates = Table.Distinct(Source)
in
Duplicates
Best regards from Germany
Manuel Bolz
🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on Github
thanks, i was overcomplicating