Forum Discussion
Lookupvalue returning incomplete values
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
1 Reply
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.
