LOOKUPVALUE function with multiple values into RESULT TABLE

[Ram_DCT]

Hi Team,

I need a quick help. I have two tables with one has unique values and another has multiple values.

I need to to repeat my LOOKUPVALUE for all the duplicates reocrds as it is going to repeat same value only. Currently it is giving me one value for each record without making any relationship between them.

Here is table where I weant to pull all the respective Project Names:

TableA:

ProjectID
101
101
101
102
103
103
104

TableB:

ProjectId	ProjectName
101	P1
102	P2
103	P3
104	P4

Expected Output [Without making any active relatiosnhip between these two tables]

ProjectID	ProjectName
101	P1
101	P1
101	P1
102	P2
103	P3
103	P3
104	P4

What I am getting using LOOKUPVALUE is:

ProjectID	ProjectName
101	P1
101
101
102	P2
103	P3
103
104	P4

Basically, it is not reapeting the output for each duplicate value - ideally, it should wokr very similar to Vlookup in excel.

Please help

Thanks,

Ram

[amitchandak · Accepted solution]

@Ram_DCT ,

New column in table A

Maxx(filter(TableB, TableA[ProjectID] = TableB[ProjectID]), TableBProjectName])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8