Lookup value

[1984]

Hi 

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

[1984]

Table 2

Table1

This is how the tables are in the model 

[mark_endicott]

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

[mark_endicott]

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

[1984]

So the Dax I'm using is 

Lookup COLUMN =

LOOKUPVALUE('TABLE 1'[ID],

'TABLE 1'[Number],

'TABLE 2'[New MSN])

[mark_endicott · Accepted solution]

Did you review your data types?

Where is the sample data?