Lookupvalue not working

[Ac583]

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 output from 0 - 24 work but i am not recieving any ouputs for Apr 2024 which is M/Y Order 25 and May 2024 which is order 26.

I've checked the inputs of the calculation and the data is there for the lookupvalue

This is only happening for my General IT Table, i have other tables which follow the same order and they are outputting M/Y order values

[HotChilli]

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]

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