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

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

 

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

sbenzaquen 

Sorry there is no pbix file. How big are you tables? Both of them