Forum Discussion

Ac583's avatar
Ac583
New Member
2 years ago

Lookupvalue not working

Hi i have this column i've created in table view using this lookupvalue equation - (M/Y Order = LOOKUPVALUE(MonthYearOrder[Order],MonthYearOrder[Month & Year],'General IT'[Month Year]) The M/Y Order...
Need Help
Show and Tell
Tutorial Requests
HotChilli's avatar
HotChilli
Community Champion
2 years ago

Let's start from the position of assuming that LOOKUPVALUE does work and there isn't a problem with the function.

So we can now isolate the data where (in some cases with your data) it's not working.

With text values that don't provide a match, you have a couple of options to investigate:

1. Hardcode the values in the LOOKUPVALUE for the specific items which are not providing a match.  This test can help identify why items are not matching, for example, there might be spaces in the fields which are expected to match.

 

2. Remove spaces and special characters by using Trim and Clean in Power Query before loading the data

  • Ac583's avatar
    Ac583
    New Member
    2 years ago

    So i manually hardcoded this in now, and it is showing the M/Y order.

     

    However the data for April and May months is still showing as blank.

     

    I've looked at the filters and there are none that would affect it, i've also looked at the relationship and can rule that out as i have the same relationship for a another table where the visualisation works