Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to determine the status of a customer based on Unique ID found in both tables. I need help with a DAX statement that will compare the the Unique ID and determine the status of Full Time vs. Part Time. The logic should be something similar to the following:
If Unique ID in Table A matchs a Unique ID in Table B then Full Time else Part Time.
Table A is Full Time Employees
Tabe B is All Employees
Thanks!
Solved! Go to Solution.
Measure = IF(COUNTROWS(RELATED(Table A))>0,"Full Time","Part Time")
Put employee names from Table B into a table visualization and this measure.
Measure = IF(COUNTROWS(RELATED(Table A))>0,"Full Time","Part Time")
Put employee names from Table B into a table visualization and this measure.
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |