Forum Discussion
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 like an additional column in the "Time Spent" table with such Issue key.
Ultimately, the my Time Spent table should look like this:
I'll be grateful if you can help me out.
Thank you,
Salvador
16 Replies
Thank you tamerj1 .
It is not working as PBI gets blocked when trying to process this formula. I think something is off with the formula. Could you please check? maybe sharing a PBI file will help to clarify.
Thank you in advance
Sorry there is no pbix file. How big are you tables? Both of them
If possible please please share your file to check what is the problem.
tamerj1 It is not possible to share the file as it contains confidential info. The Time spent table contains 313k rows and the Issue key 9k.
Is there any way to work around it?
thank you
sbenzaquen
Is there any way to split the key table? i.e. per clients or per project or per task or even a combination of them.
For example is each task has certian keys then we can split the key table by each task (not actualy split it but to add a new column [Task] to the keys table). Then if we have 90 tasks that would make 100 keys per each task. Is that something applicable in your case?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.
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] )
