At least I think it’s simple.
Here’s the syntax:
LOOKUP(“Tech Email”, “Tech”, “Email”, “Tech ID”). Ah! So frustrated. The minute I think I understand it…
Solved! Go to Solution.
Assuming the green table is called Users
Any(Select(Users[Tech ID],[Email]=[_ThisRow].[Tech Email]))
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |