Forum Discussion

amirghaderi's avatar
amirghaderi
Icon for Helper IV rankHelper IV
4 years ago
Solved

Lookup does not return value for all exact similar rows

I have a strange issue with lookup function. In the below table, booking code description is a lookup from another table based booking code column. But, as you see, it does not return the value for E...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi amirghaderi ,

     

    Try this. Please create a new calculated column.

    Booking Code Description =
MAXX (
    FILTER ( 't_BB', 't_A'[Booking Code] = 't_BB'[EA / Jobcard] ),
    't_BB'[Description]
)

     

    I look forward to hearing from you.


    Community Support Team_Gao

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amirghaderi ,

 

Try this. Please create a new calculated column.

Booking Code Description =
MAXX (
    FILTER ( 't_BB', 't_A'[Booking Code] = 't_BB'[EA / Jobcard] ),
    't_BB'[Description]
)

 

I look forward to hearing from you.


Community Support Team_Gao

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

amirghaderi's avatar
amirghaderi
Icon for Helper IV rankHelper IV
4 years ago

Thanks for this. Yes it worked!.

But, would you please advise, if you know the reason the lookup function was not working?