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.
Hi, I have 3 columns created in a master table called 'Patients' all rows are at patient level. For this example, we label the columns as A, B and C of which contains either Yes or No alongside their respective unique patientID.
I wish to build a 4th column D in the Patients table (again returning Yes or No) using the logic below
Column D = Patients in A plus Patients in B minus Patients in C.
Can you assist?
Josh
Solved! Go to Solution.
Hi @jos818 ,
Please try the below logic for your calculated column:
Group D = IF(('table'[Group A] = "Yes" || 'table'[Group B] = "Yes" ) && 'table'[Group C] = "No", "Yes", "No")
Below is the result:
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Hi @jos818 ,
Please try:
D = IF([A]="Yes"&&[B]="Yes"&&[C]="Yes","Yes","No")
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
apologies I can see the confusion. To clarify the ask with dummy numbers as follows.
I wish to create group D whereby they are either in group A or group B and not in group C.
eg. group A has 2000 patients, group B has 5000 patients, group C has 4000 patients. so group D will only return 3000 patients (with yeses)
Hi @jos818 ,
Please try the below logic for your calculated column:
Group D = IF(('table'[Group A] = "Yes" || 'table'[Group B] = "Yes" ) && 'table'[Group C] = "No", "Yes", "No")
Below is the result:
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!