Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |