Forum Discussion

Gillard_2's avatar
Gillard_2
Frequent Visitor
6 years ago

Lookup Help

I have done many lookups however this one is not playing ball and i cant work out why 😞

 
 
 

Building Name = LOOKUPVALUE(BuildingCodes1[Building],BuildingCodes1[Building Code],Printer_Report_Push_Printers[LocationCode])

LocationCode = LEFT(Printer_Report_Push_Printers[Printer Queue],3)

 

Any ideas why this lookup is not bring anything back and everything is blank? Thanks

 

 

Need Help

7 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Gillard_2 

    why dont you use relationship LocationCode - Building Code (many-to-one)?

    it would be looks more pretty 

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution
    Linkedin

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

       If possible please share a sample pbix file after removing sensitive information.
      Thanks

    • Gillard_2's avatar
      Gillard_2
      Frequent Visitor
      6 years ago

      Creating this relationship still has the same issue unfortuantely. It clearly isnt seeing them as matching despite the fact they clearly are. It wouldnt have anything to do with the fact the are Capitalised or only 3 letters long i presume

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Gillard_2 ,

     

    maybe there are non-printable characters (like space) at the end of the [Building Code]?

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

    • Gillard_2's avatar
      Gillard_2
      Frequent Visitor
      6 years ago

      I have checked and i dont believe this to be the case.

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        Hi Gillard_2 ,

        did you solve your problem?

         

        If I answered your question, please mark my post as solution, this will also help others.

        Please give Kudos for support.

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    Gillard_2 ,

     

    It means there's no matched result by LOOKUPVALUE() function, please check if there're any unprintable values in Building Code column.

     

    Community Support Team _ Jimmy Tao

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