Forum Discussion
awitt
4 years agoHelper III
Table 2 Contains string of table 1
I'm trying to return a result (red column) based on if a value in table 2 appears in part of a value in table 1. Table 1 (left) contains orders data with a tracking number which can include additiona...
parry2k
4 years agoSuper User
awitt sure, I'm not surprised, because it is trying to match each record in tracking detail.
Maybe PQ is the best solution here and will be faster. Let me take a look at that.
- awitt4 years agoHelper III
I think really I need to do some work on the source data. I'd love a simple fix within Dax but I'm not sure it'll happen.