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 |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |