Forum Discussion
Helper IMissing cell values after LOOKUPVALUE in Table View
Thank you for the clarification. It's a significant effort and I appreciate it.
I am sticking to my analysis of the problem which I posted above. The LOOKUPVALUE is not going to find anything because the data it is looking for does NOT exist. Examine the parameters which are passed to the function. Now compare with the data in the table. The row which you expect to match has a different loop3 value. So it will never find anything in the search table.
There are 2 possibilities : 1: I am not explaining my point about the LOOKUPVALUE very well
2: Your understanding of LOOKUPVALUE is not how it really works
----
There is a significant difference in the dataset where everything works ok and the one where it doesn't. For the working dataset, there are effectively 2 sets of 3 rows which have the same key values.
The dataset which does not work has 2 sets of 3 rows too. However, they do not have the same key values (Name, loop1, loop2, loop3)
Have a think and let me know.
Community ChampionWhat are you expecting to happen here?
The loop3 value is different (574973 v 575073)
so the LOOKUPVALUE ->
Results_Pre = LOOKUPVALUE(Truncated_MissingPre[Result], Truncated_MissingPre[Name], 'Truncated_Missing_DeltaPost-Pre'[Name], Truncated_MissingPre[Loop 1], 'Truncated_Missing_DeltaPost-Pre'[Loop 1], Truncated_MissingPre[Loop 2], 'Truncated_Missing_DeltaPost-Pre'[Loop 2], Truncated_MissingPre[Loop 3], 'Truncated_Missing_DeltaPost-Pre'[Loop 3])is working perfectly fine, it just won't find the data it's looking for because it's not present.
WKNHi,
The LOOKUPVALUE is referenced to the Results column. No data is returned when data is present in the data source.