Forum Discussion
Find text in a column from another table
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
That would make 2.8 bilion iterations. In addition to CONTAINSSTRING which is a slow function. Let me think if there is another way to do that.
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.
Great. Let me know when done so I can lead you through the rest if the steps
