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

Yes that is something we could do. We can organize Issue Keys by project i.e. PBRID-8 and PBRID-67 are part of Project Bridge. PALMA-2 and PALMA-51 are part of Project Alma.

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

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