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
sbenzaquen's avatar
sbenzaquen
Icon for Helper I rankHelper I
4 years ago

Done - I have now 48 distinct "Project Keys" (and 9k Issue Keys)

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

sbenzaquen 
Great. Now connect bothe tables via Project Columns. Then use 

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