Forum Discussion
lg1551
Resolver II
Resolver IILOOKUPVALUE 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!
sevenhills
Super User
Super UserTried 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
lg1551Resolver II
Resolver III 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!