Create a column to easily use as a filter

[jos818]

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 

[v-jianboli-msft]

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.

[jos818]

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) 

[Anonymous · Accepted 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 !!!