Forum Discussion
GRikerWillig
5 years agoRegular Visitor
Vlookup for Text between multiple data sets
Hi All, I'm sure I'm missing something incredibly obvious, but I'm struggling to perform a VLOOKUP type function between a 2 sets of data. The first is a live pull from our CRM system that I need to...
- 5 years ago
- 5 years ago
I checked to confirm that all of the values I'm pulling are text. This is the error that I keep getting:
Not sure how to get around this one...
Fowmy
5 years agoSuper User
GRikerWillig
Make sure you have the same data type used the LOOKVALUE function correctly, can you the dax formula ?
https://dax.guide/lookupvalue/
- GRikerWillig5 years agoRegular Visitor
I checked to confirm that all of the values I'm pulling are text. This is the error that I keep getting:
Not sure how to get around this one...
- GRikerWillig5 years agoRegular Visitor
Got it! Looks like I was creating a measure instead of a new column which explains the error. Thank you so much for your help!