Help Lookupvalue text

[sbianco]

Hi,

I need help with this scenario

I have A sheet called "examples" that contains a column called last_discoverer_hostname linked with another sheet called "manged" that contains two columns: "hostname" and "machine_domain". My scope is to associate the machine_domain at the l"ast_discoverer_hostname". I have performed the following query Discoverer Domain = LOOKUPVALUE(examples[last_discoverer_hostname],Manged[machine_domain],0), but I have the following error: "Function 'LOOKUPVALUE' does not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.".
Someone, could you kindly help me?

Regards

Sly

[audreygerred · Accepted solution]

This is saying that one of the two values you are comparing is text and the other is integer. When comparing the two values they data type needs to be the same. If the text value is an int, but being displayed as a string you could do the following: LOOKUPVALUE(Table[Column], Table[TextColumn], VALUE(OtherTable[IntegerColumn]))

VALUE function (DAX) - DAX | Microsoft Learn

You could also convert the int to text and compare that way:

LOOKUPVALUE(Table[Column], Table[TextColumn], FORMAT(OtherTable[IntegerColumn], "0"))

FORMAT function (DAX) - DAX | Microsoft Learn

[sbianco]

Hi,

Thanks, it's working