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 Exce...
Tymek , New column in Table 1
If([Status] = "Retired", countrows(filter(Table2, Search(Table1[Application Name],Table2[Application Name],,0) >0)) , blank())
Tymek , New column in Table 1
If([Status] = "Retired", countrows(filter(Table2, Search(Table1[Application Name],Table2[Application Name],,0) >0)) , blank())