Forum Discussion
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...
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.
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.
Anonymous Thanks a lot for your help. Apologies for the delay in responding to your solution.