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

sbenzaquen 

Great. Let me know when done so I can lead you through the rest if the steps

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)

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

    tamerj1 - see my reply above (Message 12). What is next? thanks

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

        It is loading "work in on it" for a while....I think the data is still too big. My time spent table is 313k...

         

        To make sure I understood it correctly, how am I supposed to link the two tables? I still don't have any link with the Time Spent table as there is no issue/project key to use...Do I need to develop one column on the time spent table? I only did the project key in the Issue Key table...

  • 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]
)