Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a field StaffMemberType where I want to group values into different categories. Having trouble with the syntax:
If the type is AnesthesiologistAssistant, CRNA or CertifiedAnesthesiologistAssistant then it's CRNA
IF its physician, medicaldoctor or doctorofosteopathy then it's physician
Else it's Other.
This is what I have that is not working:
Job Family = IF('QGenda Compliance'[StaffMemberKey] IN ("AnesthesiologistAssistant", "CRNA", "CertifiedAnesthesiologistAssistant", "CRNA", IF('QGenda Compliance'[StaffPayrollId] IN ("Physician", "MedicalDoctor", "DoctorOfOsteopathy"), 'Physician', "Other")))
Solved! Go to Solution.
@Anonymous , Your logic seems correct I doubt the columns you are using
[StaffMemberKey] and [StaffPayrollId] they do not seem like column hold those values. Also, this is case sensitive comparison
Job Family = Switch( True() ,
'QGenda Compliance'[StaffMemberKey] IN {"AnesthesiologistAssistant", "CRNA", "CertifiedAnesthesiologistAssistant"}, "CRNA"
, 'QGenda Compliance'[StaffPayrollId] IN {"Physician", "MedicalDoctor", "DoctorOfOsteopathy"}, "Physician"
, "Other")
Revised, but still not working. Only getting the result "Other"
Job Family = IF('QGenda Compliance'[StaffMemberKey] IN {"AnesthesiologistAssistant", "CRNA", "CertifiedAnesthesiologistAssistant"}, "CRNA", IF('QGenda Compliance'[StaffPayrollId] IN {"Physician", "MedicalDoctor", "DoctorOfOsteopathy"}, "Physician", "Other"))
@Anonymous , Your logic seems correct I doubt the columns you are using
[StaffMemberKey] and [StaffPayrollId] they do not seem like column hold those values. Also, this is case sensitive comparison
Job Family = Switch( True() ,
'QGenda Compliance'[StaffMemberKey] IN {"AnesthesiologistAssistant", "CRNA", "CertifiedAnesthesiologistAssistant"}, "CRNA"
, 'QGenda Compliance'[StaffPayrollId] IN {"Physician", "MedicalDoctor", "DoctorOfOsteopathy"}, "Physician"
, "Other")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |