Forum Discussion

chakrared's avatar
chakrared
Regular Visitor
3 years ago

Make Table based on values that exist in 2nd table

Noob help needed...

 

I have table 1 (All_Sites)

Columns are URL, Creator, Items ,LastAccess (EG)

URLCreatorLastAccessFiles
someurl.comRod11/11/2020100
someotherurl.nlJane12/12/2010200
andanother.orgFreddy13/01/2015300

 

And table 2 (Users)

Column Names are Username, DisplayName

UsernameDisplayName
domain\RodJFRod
anotherdomain\FreddyJRFreddy

 

I'd like to make a table 3 that was the same as table 1 but only included where the displayname in table 2 is matched with the creator in table 1 (displayname is related to creator)

Like so....

table 3 (SummaryTable)

URLCreatorLastAccessFiles
someurl.com Rod11/11/2020100
andanother.orgFreddy13/01/2015300
    

 

Any guidance is appreciated

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

     

    I think with intersect it should work.

    intersect(table1,table2)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi chakrared ,

     

    According to your description, you want to get a summary table, right? Here are my steps you can follow as a solution.

    (1) Create a relationship on the [All_Sites] table and the [Users] table.

    (2)We can create  a table.

    Summary Table = SELECTCOLUMNS( 'Users' , "Creator" , 'Users'[DisplayName] , "URL" , RELATED(All_Sites[URL]) ,"Files" , RELATED(All_Sites[Files]) , "Last Access" ,RELATED('All_Sites'[LastAccess]  ))

    (3) Then the result is as follows.

     

    Best Regards,

    Neeko Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.