Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Lookupvalue returns blank for some records

When I use LOOKUPVALUE, why some of the records are BLANK. It

LookupValue = LOOKUPVALUE(factMCCyclePlanCHANNEL_d[UQ_CP_Qtr],

factMCCyclePlanCHANNEL_d[UQ_CP_Qtr],factCallDetail_d[UQ_Qtr])

Anonymous
5 years ago
Hi Anonymous ,

Could you please mark your post as Answered since it has been resolved? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

Best Regards

5 Replies

amitchandak
Super User
5 years ago
Anonymous , I doubt missing match between

factMCCyclePlanCHANNEL_d[UQ_CP_Qtr] and factCallDetail_d[UQ_Qtr]

Check for that.

Also check

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Anonymous
Not applicable
5 years ago
Hi Anonymous ,

The result is depend on the data in the table factMCCyclePlanCHANNEL_d. Could you please provide some sample data in table factMCCyclePlanCHANNEL_d?

Best Regards
- Anonymous
  Not applicable
  5 years ago
  I did have duplicate values in the table. I managed to resolve it by removing duplicates
  - Anonymous
    Not applicable
    5 years ago
    Hi Anonymous ,
    
    Could you please mark your post as Answered since it has been resolved? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.
    
    Best Regards