Lookup Help

[Gillard_2]

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

[v-yuta-msft]

@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.

[az38]

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

[Gillard_2]

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

[amitchandak]

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

[mwegener]

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]

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

[mwegener]

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.