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...
vanessafvg I checked and rechecked the Volunteer IDs and they are all distinct values. Now some of the names are the same but that shouldn't matter.
It's the same ones happening over and over again. Even tried it on a different computer to see if there was a cache issue but same exact results.
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
