Forum Discussion
Solved
LOOKUPVALUE From One Table to Another Based on Calculated Columns?
Table 1 has a 'Generate Series' calculated column which provides a list of values. Table 2 has a 'Category Column' and the calculated column for the 'Category Score'. I am trying to lookup the '...
I figured it out. It was the decimal from Category Score that was the culprit. I wrapped that calculated column in a "FIXED" function and it works fine now. Thank you for troubleshooting with me!
Tried this and it worked!
Table3 = GENERATESERIES(1, 10, 1)
Measure
Value - Category 3 = LOOKUPVALUE(Table2[Category], Table2[Category Score], SELECTEDVALUE(Table3[Value]))
Relationships
it worked when I tried
I figured it out. It was the decimal from Category Score that was the culprit. I wrapped that calculated column in a "FIXED" function and it works fine now. Thank you for troubleshooting with me!
If any of my solution helped, marked my reply also as "Accept as Solution"