Lookupvalue function does not return results occasionally?

[Anonymous]

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 · Accepted solution]

@Anonymous , Try like

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

[Anonymous]

@amitchandak 

Thank you Sir for your help.

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

Thanks,