topic Re: Lookup value in DAX Commands and Tips

Lookup value

1984 — Mon, 16 Dec 2024 14:38:16 GMT

I'm hoping someone can support me. I want to create what I thought would be a simple lookup dax

The result column is type text with a mixture of text and numbers,

the search column is type text with a mixture of text and numbers,

and the final search is type text with a mixture of text and numbers. However, it creates an error of type text to type integer the search value on both sides will have something like 11C800707.

Please let me know if you require any further details/table details

Thanks in advance

Re: Lookup value

mark_endicott — Mon, 16 Dec 2024 15:00:51 GMT

1984 - Start off by reviewing your data types in Power Query, and then on the front end in the Model or Table views. It sounds like something is wrong here.

If all good, sample data and a copy of the DAX you are using will help!

Re: Lookup value

1984 — Mon, 16 Dec 2024 15:33:04 GMT

So the Dax I'm using is

Lookup COLUMN =

LOOKUPVALUE('TABLE 1'[ID],

'TABLE 1'[Number],

'TABLE 2'[New MSN])

Re: Lookup value

mark_endicott — Mon, 16 Dec 2024 15:36:38 GMT

Did you review your data types?

Where is the sample data?

Re: Lookup value

1984 — Mon, 16 Dec 2024 15:45:24 GMT

Table 2

Table1

This is how the tables are in the model

Re: Lookup value

mark_endicott — Mon, 16 Dec 2024 15:53:38 GMT

1984 - I suggest you check your data types. your DAX works perfectly for me: