Forum Discussion
Solved
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 ty...
Did you review your data types?
Where is the sample data?
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?