Forum Discussion

angieleman's avatar
angieleman
Icon for Advocate I rankAdvocate I
5 years ago
Solved

LOOKUPVALUE results are not consistent for the same input

I'm seeing inconsistent results with Lookupvalue and need another couple sets of eyes.   Table 1 (source) - This table starts as a Reference table in Power Query and is then Grouped in M on the pri...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    angieleman I have also struggled with LOOKUPVALUE. I tend to use MAXX(FILTER(...)...) syntax instead. Works regardless if one or more values are pulled back and seems to work more consistently than LOOKUPVALUE when there should be only 1 row anyway. I'm not certain because I haven't really dug into it but I wonder if LOOKUPVALUE has an issue when a blank row appears and since this counts as having more than 1 row in the results, it ends up returning the default blank when more than one row result from the filters provided. It's just a guess but, as I said, MAXX(FILTER takes care of it.