Forum Discussion

Allan_Zeng's avatar
Allan_Zeng
Frequent Visitor
3 years ago
Solved

Lookup value

Hello Team,   Can someone help to support this issue? I have 2 tables as below:  Table "Factor List": Table "Individual" : The column "Factor" in red is the result that I wanted. T...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    Allan_Zeng 

    you can create a column

    Column = 
var _target=maxx(FILTER('Factor List','Factor List'[Department]='Individual'[Department]&&'Factor List'[Role]=Individual[Role]&&'Factor List'[Target%]<='Individual'[Target%]),'Factor List'[Target%])
return maxx(FILTER('Factor List','Factor List'[Department]=Individual[Department]&&'Factor List'[Role]=Individual[Role]&&'Factor List'[Target%]=_target),'Factor List'[Factor])

    pls see the attachment below

ryan_mayu's avatar
ryan_mayu
Super User
3 years ago

Allan_Zeng 

you can create a column

Column = 
var _target=maxx(FILTER('Factor List','Factor List'[Department]='Individual'[Department]&&'Factor List'[Role]=Individual[Role]&&'Factor List'[Target%]<='Individual'[Target%]),'Factor List'[Target%])
return maxx(FILTER('Factor List','Factor List'[Department]=Individual[Department]&&'Factor List'[Role]=Individual[Role]&&'Factor List'[Target%]=_target),'Factor List'[Factor])

pls see the attachment below

  • Allan_Zeng's avatar
    Allan_Zeng
    Frequent Visitor
    3 years ago

    Hello Ryan,

     

    Thanks a lot for your solution!

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      3 years ago

      you are welcome