Forum Discussion
Solved
Lookup function returns Error
Hi all, I have a problem to make a Lookup function work in my report. I get the error "A table of multiple values was supplied where a single value was expected". I have tried to use the classic L...
nbrandborg , New column in Table 1
sumx(filter(Table2, Table1[Class] = Table2[Class]), Table2[qty])
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
Hi nbrandborg .
The best possible solution would be to do the same using Merge in Power Query.
Regards,
Sanket Bhagwat