Lookupvalue returning incomplete values

[kevinconseil]

Hi Everyone,

I would like to lookup an article sub category from my Planned Sales to my Sales table (cf. screenshots).

Current Scenario: I use the Lookupvalue function in my Sales table- Lookupvalue(Planned Sales [article sub category], Planned Sales [article sub category], Sales [article sub category]) - to retieve the corresponding sub category in the Planned Sales table. However this give me "partial data" (cf. screenshot 1)

Data model:

- There are no relationship between the 2 tables however both are connected to a third table (contain all possible aggregation of customer & sub category)

- Both tables are connected to a date table

Anyone having a solution? One idea I had was to make the Lookupvalue function ignoring the relationship with the other tables (I searched online but did not find anything on this)

Screenshot 1: Sales table

 

Screenshot 2: Planned Sales table

[d_gosbell]

Are you able to upload an example file with some dummy data that replicates this issue? I can't see anything in your screenshots or your explanation that would explain this behaviour so there is something else going on here.