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
This should work as a calcualted column in your products table
Qty = LOOKUPVALUE(LookUpT[Qty], LookUpT[Class], ProductsT[Class]) You can also do all this in PQ though a simple merge. Probably best
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |