error in calculated column. Please help.

[Kiranbc]

Hi All, 

I am gettting below error when i try to populate client names from Sheet A to sheet B using calculated column. I tried with merge queries in power query but the file size is huge and I am unable to save this file. Let me know for any work around. 

Sheet A

[amitchandak · Accepted solution]

@Kiranbc , That will give you a table, not a column

A new column in Table 2

MAxx(filter(Table1, Table1[Projectid] = Table2[ProjectID]), Table1[Client])

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