topic Re: lookupvalue no longer working after Data Refresh in DAX Commands and Tips

lookupvalue no longer working after Data Refresh

MSW — Fri, 18 Mar 2022 17:26:37 GMT

I have a simple Vlookupformula for two columns in Table2. The values are in Table1 and appear to be present. It was working well until I did a data refresh recently all of a sudden it is no longer retreiving any values. Nothing should have changed with the refresh. What could be the cause of this malfunction?

Re: lookupvalue no longer working after Data Refresh

m3tr01d — Sat, 19 Mar 2022 01:01:39 GMT

MSW Most likely, when you refresh the model, you added duplicate values in your lookup table. Lookupvalue will return an error if there are duplicates.

Re: lookupvalue no longer working after Data Refresh

MSW — Sat, 19 Mar 2022 19:30:43 GMT

m3tr01d Thank you for the reply. I had duplicates before and it was working. Im not getting an error message its returning nothing at all now. As if the formula is not even there. I have tried making a new column and re-write the formula too.

Re: lookupvalue no longer working after Data Refresh

MSW — Sun, 20 Mar 2022 00:54:31 GMT

Resolved. Not sure why it was not working the same as previous but I built another table with the unique IDs and the column value and referenced that table instead to lookup the value into the target table.

Re: lookupvalue no longer working after Data Refresh

HotChilli — Sun, 20 Mar 2022 00:57:21 GMT

One of the best ways to test lookupvalue is to hardcode the value to be searched for so try putting a value that you know exists as your search term.

if no result value is returned, you can investigate the field that was expected to match (see if there are spaces in it or hidden characters etc)

Re: lookupvalue no longer working after Data Refresh

Anonymous — Mon, 21 Mar 2022 02:51:53 GMT

I am having the same problem too. Started no more than 2weeks ago