Forum Discussion

awitt's avatar
awitt
Icon for Helper III rankHelper III
4 years ago

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...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

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.

  • awitt's avatar
    awitt
    Icon for Helper III rankHelper III
    4 years ago

    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.