Forum Discussion

Raj12's avatar
Raj12
Helper III
2 years ago
Solved

Fetch multiple rows data from another table based on matching ID's

I have two spaerate tables that can't be linked together directly. Table 1 has User with multiple ID's and Table 2 has unique users. I need to create new calculated column in table 2 for matching us...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • danextian's avatar
    danextian
    2 years ago

    Hi Raj12 

     

    Try this:

    new calculated column = 
VAR __tbl =
    FILTER ( table1, table1[user] = EARLIER ( table2[user] ) )
RETURN
    CONCATENATEX ( __tbl, [Conversation ID], ";" )

     

danextian's avatar
danextian
Super User
2 years ago

Hi Raj12 

 

Try this:

new calculated column = 
VAR __tbl =
    FILTER ( table1, table1[user] = EARLIER ( table2[user] ) )
RETURN
    CONCATENATEX ( __tbl, [Conversation ID], ";" )