Hi, how do I compare data from a column that is in another table? Example: I have two tables [records] and [users], in a slice of the table “records” I want to compare if the USEREMAIL is equal to the email registered in the table “users”
For example with the IN expression… IN([EmailAddress],Users[Email]). The result is either TRUE or FALSE.
User | Count |
---|---|
33 | |
25 | |
22 | |
21 | |
15 |