Forum Discussion

lg1551's avatar
lg1551
Resolver II
3 years ago
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 '...
Need Help
  • lg1551's avatar
    lg1551
    3 years ago

    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!

lg1551's avatar
lg1551
Resolver II
3 years ago

Table 1 is a calculated table with the "Value" column generated using "Generate Series"

 

Table 2 is a table with the Category dimension and a calculated column for Category Score.

sevenhills's avatar
sevenhills
Super User
3 years ago

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