Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have the following DAX that returns whether or not there is a duplicate value on the 'ODS' table:
Solved! Go to Solution.
Perhaps:
Duplicates = VAR __table = FILTER('Active',Active[Name] = 'ODS'[EMPLOYEE_NAME] && 'Active'[Manager] = 'ODS'[MANAGER_NAME]) RETURN IF(COUNTX(__table,[Name])=1,"NO","YES")
Perhaps:
Duplicates = VAR __table = FILTER('Active',Active[Name] = 'ODS'[EMPLOYEE_NAME] && 'Active'[Manager] = 'ODS'[MANAGER_NAME]) RETURN IF(COUNTX(__table,[Name])=1,"NO","YES")