Forum Discussion

sbenzaquen's avatar
sbenzaquen
Icon for Helper I rankHelper I
4 years ago

Find text in a column from another table

Hi experts, I need help with something I'm working on. I want to search in the "Notes" column from the "Time Spent" table if it contains any of the "Issue Keys" of the "Issue Key" table. If so, I'd...
Need Help
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi sbenzaquen 

please use

Issue Key =
MAXX (
    FILTER (
        VALUES ( 'Issue Key'[Issue Key] ),
        CONTAINSSTRING ( 'Time Spen'[Notes], 'Issue Key'[Issue Key] )
    ),
    'Issue Key'[Issue Key]
)