how to look up a value in another table?

[JesusAguirre]

Hi community!

I have a problem, I have two tables without any relationship, but there is a value which matches both, and when I do a lookupvalue it only brings me the value of some cells and of the others not even if they coincide:

The format of the data of the numbers is the same in the two tables.

Can you help me to solve what the problem?

Regards.

JA

[JesusAguirre · Accepted solution]

Hi community!

I already resolved it!! 😁

I converted the two float values ​​to string with the following function: Convert ([float value], String)
And then I did the lookupvalue and it already brought me the necessary data.

Thanks!!

Regards.

JA

[HotChilli]

It won't make a difference with the format of the decimal type.  It's still a floating point number behind the scenes.  I think you'll have to change the data type to fixed decimal or , in power query a currency type.

--

It's quite unusual to use a lookup like this. I could compare it to doing a join between tables. A decimal type would never be used.

--

Alternatively, the data shown has 1 record per date.  If that is true for the whole dataset, just use the  date in the lookupvalue 

[HotChilli]

It will depend which columns are in the lookup I suppose.

It's possible the decimal values are not matching (if you are using those).  You probably want a fixed decimal type to avoid the challenges of matching approximate values.

[JesusAguirre]

Hi @HotChilli 

What happens is that I have these two values ​​that are the same and with one if you find it and with the other not

try putting the two decimal data to 10 digits but it keeps giving me the same problem.

Thank you and I hope you help me find a solution!

Regards.

JA

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file with the LOOKUPVALUE() function already written there.