Forum Discussion

A_Vijgo's avatar
A_Vijgo
New Member
2 years ago
Solved

Lookup from same table

Hi   I am having trouble with looking up for data from the same table. What i am trying to achieve is to capture line manager hierarachy that rolls up to CEO for that particular month (It is a mont...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    A_Vijgo 

    pls try this

    LM1 = MAXX(FILTER('Table','Table'[EID]=EARLIER('Table'[Line Manager ID])),'Table'[Line Manager ID])

LM2 = MAXX(FILTER('Table','Table'[EID]=EARLIER('Table'[LM1])),'Table'[Line Manager ID])

LM3 = MAXX(FILTER('Table','Table'[EID]=EARLIER('Table'[LM2])),'Table'[Line Manager ID])

    pls see the attachment below