Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

LookupValue not returning all values

I am at a loss and have dug through Google looking for something similiar.   I used this formula to create a column   FY22%Comp = MROUND( IF(Preconstruction[TaskStartDate]>DATE(2022,06,30),0,if(...
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
3 years ago

I'd guess there isn't a single unique match (i.e. zero or multiple matches) or possibly a floating point error issue.

 

Without actually looking at the tables and preferably the pbix, it's difficult to say for sure. Can you share a dummy file that reproduces this issue?