How do I identify a string in a coulmn and find it in another table comment section

[AS123]

Hello there,

I am new to Power BI and I have a query that I need help with.

I have two datasets: 

1) Employee: 

2) Request Comment

I want to be able to find the request comment is for which employee based on the name context in comment. Is there a way to do that in Power BI?

Thanks

[Anonymous · Accepted solution]

Hi  @AS123 ,

Here are the steps you can follow：

1. Create calculated column.

Column =
MAXX(
    FILTER(ALL('Request Comment'),
    CONTAINSSTRING('Request Comment'[Request Comment],'Employee'[Employee Name])),'Request Comment'[Request Comment])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly