Forum Discussion
LOOKUPVALUE Randomly Returns Blank Values
I have a dataset with Names of volunteers and each one is given a unique ID number. In another table, I have some contacts and in that table, there is a column of with the Volunteer ID of the volunt...
I having a very similar issue.
50% of values return the lookup value correctly the others are blanks.
I’ve checked the record returning blanks and the search column and lookup column are absolutely fine and matching. Same data type and I even went to the step of trimming left and right in both fields to ensure the lookups value was found.
Why some are working and others are not it has me beat.
An updates on this one ?
50% of values return the lookup value correctly the others are blanks.
I’ve checked the record returning blanks and the search column and lookup column are absolutely fine and matching. Same data type and I even went to the step of trimming left and right in both fields to ensure the lookups value was found.
Why some are working and others are not it has me beat.
An updates on this one ?
shaunwilks can you share your pbix?
Unfortunately I cannot as it contains sentive data.
I will rebuild the model from the start and see how I go.
There is a join to the label I am using in the lookup so wonder if that is impacting