Forum Discussion

o59393's avatar
o59393
Post Prodigy
2 years ago

Lookup value not working

Hi all

 

I have used a lookupvalue in calcuated column, for some reason I do not know, the lookupvalue does not retrurn the value on all the rows:

 

 

As seen above, the column Merged Demand Incremental has repeated values but it only displays the result for the a 2023 year and a null for the rest.

 

Does anybody know what could be wrong?

 

Thanks.

Need Help
Show and Tell

2 Replies

  • vicky_'s avatar
    vicky_
    Super User
    2 years ago

    It could possibly be an issue that there is more than one possible value for lookup conditions. If you check the docs, LOOKUPVALUE() will only give a value if there is one distinct value, but you can specify an alternative value if that case happens.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    Could be because of some extrac charactes in the Merged string of both/one table.  If it does not help, then share the download link of the PBI file.