Forum Discussion
Error in new column using lookup value
Hello, I have the following new column locationCode = LOOKUPVALUE(locations[code],locations[id],salesOrderLines[locationId]) locations[code] is a valid field in the locations table. I f...
lbendlin
Super User
Super UserPlease advise what I am doing wrong here.You are using LOOKUPVALUE 🙂
But seriously, let go of your Excel thinking and embrace the Power BI way of doing things. Use the data model if you can, and TREATAS if you must. Only use LOOKUPVALUE if there is absolutely no other way.