Forum Discussion
error in calculated column. Please help.
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
Anonymous , 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
1 Reply
Anonymous , 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