Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JSR
Helper II
Helper II

Create new table from multiple tables

Hi,

 

Having 4 similar tables as:

JSR_0-1718271968756.png

 

What can I do to have a new table with Only unique Owners names?

JSR_0-1718272289853.png

 

I'm creating it like this, but it doesnt show all users.

 

let
    Source = Table.NestedJoin(email, {"owneridname"}, appointment, {"owneridname"}, "appointment", JoinKind.FullOuter),
    #"Merged Queries" = Table.NestedJoin(Source, {"owneridname"}, phonecall, {"owneridname"}, "phonecall", JoinKind.FullOuter),
    #"Removed Other Columns" = Table.SelectColumns(#"Merged Queries",{"owneridname"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns"),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates",{{"owneridname", "Name"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each ([Name] <> null and [Name] <> "Power Platform Admin Admin"))
in
    #"Filtered Rows"

 

 

 

1 ACCEPTED SOLUTION
ManuelBolz
Responsive Resident
Responsive Resident

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

ManuelBolz_1-1718282499181.png


Best regards from Germany
Manuel Bolz


🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on Github

View solution in original post

2 REPLIES 2
ManuelBolz
Responsive Resident
Responsive Resident

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

ManuelBolz_1-1718282499181.png


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 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors