Forum Discussion
Lookup value
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
Did you review your data types?
Where is the sample data?
5 Replies
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!
So the Dax I'm using is
Lookup COLUMN =
LOOKUPVALUE('TABLE 1'[ID],
'TABLE 1'[Number],
'TABLE 2'[New MSN])
Did you review your data types?
Where is the sample data?
Table 2
Table1
This is how the tables are in the model
