Forum Discussion
jos818
Helper I
Helper ICreate a column to easily use as a filter
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...
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 !!!
jos818Helper I
Helper Iapologies 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 !!!