Forum Discussion
1984
Helper I
Helper ILookup 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?
mark_endicott
Super User
Super User1984 - 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!
1984Helper I
Helper ISo the Dax I'm using is
Lookup COLUMN =
LOOKUPVALUE('TABLE 1'[ID],
'TABLE 1'[Number],
'TABLE 2'[New MSN])
- mark_endicott
Did you review your data types?
Where is the sample data?