Forum Discussion

mikesqu's avatar
mikesqu
Helper I
3 years ago
Solved

Lookupvalue Missing Values

Hi all,    Hopefully someone can help me with this issue. I have two tables, joined by a source name. On the secondary table I have the source media stored, so I am using the following formula on t...
Need Help
  • mikesqu's avatar
    mikesqu
    3 years ago

    FYI I just duplicated the source table and the lookupvalue worked perfectly. Must have been a bug in the system. 

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
3 years ago

Hi mikesqu ,

 

If you look at the formula alone, it should be caused by no query result in the target table (Source[Source Name]). You can refer to the following blog for a detailed description of this function.

Power BI LOOKUPVALUE | Examples of LOOKUPVALUE Dax Function (wallstreetmojo.com)


Also, if the problem still exists, can you provide the relevant test data and describe it, so that I can answer it for you as soon as possible.


Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mikesqu's avatar
mikesqu
Helper I
3 years ago

Hi Henry,

 

This is what I don't understand. The image below is directly from the clients table, showing that the new media column using the formula above is not recognising that the both cases of Google - Desktop are the same, as well as the three referrals.