Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Can someone help me, I don't know how to I apply the filter in this scenario.
Should I use Power Query?
Solved! Go to Solution.
@Anonymous , It should be like
Dental1 = if(
'CME 20-22'[Category] in {"Dentist","Endodontics","Forensic odontology","Oral and maxillofacial surgery","Oral medicine","Orthodontics","Paediatric dentistry","Periodontics","Prosthodontics","Special needs dentistry" }
&& 'CME 20-22'[Product Class]="Dental Indemnity",
SWITCH(TRUE(),
'CME 20-22'[Basis]="Dental specialist in training",1,
'CME 20-22'[Basis]="Employer indemnified only",1,
'CME 20-22'[Basis]="Gratuitous services only",1,
'CME 20-22'[Basis]="New graduate",1,
'CME 20-22'[Basis]="Non-practising",1,
0),
0)
@Anonymous , It should be like
Dental1 = if(
'CME 20-22'[Category] in {"Dentist","Endodontics","Forensic odontology","Oral and maxillofacial surgery","Oral medicine","Orthodontics","Paediatric dentistry","Periodontics","Prosthodontics","Special needs dentistry" }
&& 'CME 20-22'[Product Class]="Dental Indemnity",
SWITCH(TRUE(),
'CME 20-22'[Basis]="Dental specialist in training",1,
'CME 20-22'[Basis]="Employer indemnified only",1,
'CME 20-22'[Basis]="Gratuitous services only",1,
'CME 20-22'[Basis]="New graduate",1,
'CME 20-22'[Basis]="Non-practising",1,
0),
0)
Legendary!! Bro!
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
111 | |
104 | |
85 | |
65 | |
63 |