Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Lookupvalue function does not return results occasionally?

I am trying to return PI number from Master calendar table using LOOKUPVALUE function.

 

This is the function:

 

 

Just noticed some dates do not have PIs returned, even though some other dates (exactly same dates) do?

 

Help is needed please!

 

Thanks,

Chris

 

  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try like

     

    maxx(filter('Master Calendar Table', 'Master Calendar Table'[Date] = datevalues(Allincident[Date])), 'Master Calendar Table'[PI] )

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Try like

     

    maxx(filter('Master Calendar Table', 'Master Calendar Table'[Date] = datevalues(Allincident[Date])), 'Master Calendar Table'[PI] )

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak 

       

      Thank you Sir for your help.

       

      It works like a dream. Do you know the reason why LOOKUPVALUE did not work?

       

      Thanks,