Forum Discussion
Getting error message: The name 'LOOKUPVALUE' wasn't recognized. Make sure it's spelled correctly."
Hello, I am getting the following error message when using LOOKUPVALUE.
"The name 'LOOKUPVALUE' wasn't recognized. Make sure it's spelled correctly."
Here is the syntax of the formula in Power BI:
LOOKUPVALUE(DisruptionRTO[RTOScore],DisruptionRTO[TimeSinceDisruptionRTO],ImpactProfile[TimeSinceDisruptionRTO])
Image 1 is the ImpactProfile table.
Image 2 is part of the DisruptionRTO table.
I would be grateful for any help in solving this. Thank you!
Thank you for the quick response. I was adding a column. AM I not adding the right thing?
Here is the dialogue.
Thak You!
5 Replies
CamJohnston what is the actual error? Are you adding a column or a measure?
Thank you for the quick response. I was adding a column. AM I not adding the right thing?
Here is the dialogue.
Thak You!
CamJohnston I expected this, you are adding a column in Power Query and LOOKUPVALUE function is a DAX function. You need to add a calculated column using DAX and that's where you will use LOOKUPVALUE
parry2k Kudos! Thank you for the very quick and insightful help. Much appreciated.
CamJohnston glad you figured it out, although it doesn't matter but you accepted your own reply as an answer, I would recommend accept the reply as a solution that solved the issue so that others can find it easily. Good luck!
