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 am also having this issue, where certain values are not returning results even though I've confirmed they do match data in the lookup column.
I tried using TRIM to rule out any leading or trailing spaces, with no luck. I've tried deleting the relationships to other tables in case that was interfering, but it did not help. It works for 95% of the data, but the remaining 5% return blank.
I have the same issue. A lookup randomly returns blanks for some rows.
BrightWork Asset = LOOKUPVALUE('BW Assets'[bw_name], 'BW Assets'[bw_brightworkassetid], campaigns[_bw_brightworkasset_value])
I have sort by the _bw_brightworkasset_value column to prove they are they same.