Question: Which DAX function compares a column of values in Table A with a similar column in Table B, and returns the values the are not found in Table B?
- COMPARE
- FINDUNIQUE
- EXCEPT
- SWITCH
Answer: The correct answer of the above question is Option C:EXCEPT