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...
smpa01
5 years agoCommunity Champion
GRikerWillig can you try this relationship-proof column
Column= CALCULATE(MAXX(FILTER('Table 2','Table 2'[Owner]=max('Table 1'[Sales Person])),'Table 2'[Region]))