Forum Discussion

BILearn's avatar
BILearn
Frequent Visitor
4 years ago
Solved

Lookup value based on Max Value from another column.

Hi all,  I am trying to achieve the below result in My Table. Established relationship between Lookup Table and My Table using Value ID.   I am trying to lookup Result  in Lookup table for Z1 and...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  BILearn ,

     

    If you final data is 

     

    please try:

    Column = 
var _value=CALCULATE(MIN('Lookup Table'[Ep No]),ALLEXCEPT('Lookup Table','Lookup Table'[Value ID]))
return LOOKUPVALUE('Lookup Table'[Result],[Ep No],_value,[Value ID],[Value ID])

     

    Or if you data is as the original shown, please change MIN() to MAX()

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Super User
4 years ago

BILearn ,

new column in my Table

Maxx(filter('Lookup Table', 'Lookup Table'[Value ID] = 'My Table'[Value ID]) , 'Lookup Table'[Result])

trd5004's avatar
trd5004
Regular Visitor
2 years ago

Hello,

 

Can you use this function with the allexcept function?  I want to return values based on other criteria.

 

Thanks!