Forum Discussion
Solved
Check in another table if value contains
Hello,
I've got two tables:
1. Table Application
| Application Name | Status |
| Teams | Active |
| Excel | Retired |
2. Table Report
| Application Name | ID |
| MS Teams | 1 |
| Microsoft Excel | 2 |
| Word | 3 |
| Microsoft Outlook | 4 |
If an application is of status "Retired", I would like to check if it is present in the Table Report (Please note that application names are not the same, but names in Table Report contain some words from Table Applicaton.).
Any help is highly appreciated
Tymek , New column in Table 1
If([Status] = "Retired", countrows(filter(Table2, Search(Table1[Application Name],Table2[Application Name],,0) >0)) , blank())
1 Reply
- amitchandak
Super User
Tymek , New column in Table 1
If([Status] = "Retired", countrows(filter(Table2, Search(Table1[Application Name],Table2[Application Name],,0) >0)) , blank())