Adding new column with multiple conditions (easy for most i am sure)

[cwnoll]

i am certain that this will be a simple answer, i am just totally drawing a blank.

my data looks like the following :

Location	Date	Type	Complete
Texas	1/1/2019	911	1
Texas	10/9/2019	911	0
New York	6/7/2018	Regular	0
California	6/7/2018	Non 911	1
New York	7/25/2018	Transfer	1
New York	2/2/2019	Non 911	1

what i am trying to accomplish is the following.

1) add new column that we will call productType

2) logic i am going after is this:

if location = Texas and Type = 911

   then "Emergency",

elseif location = New York && Type = Non 911

  then "Non-Emergency"

essentially I am trying to add a new column that looks at 1)what is the location 2)what is the type 3)set new column to whatever i put here

thoughts? Thanks so much in advance!

[Anonymous · Accepted solution]

Hi

In your table, select Add a new column 

if (AND(table1[location] = Texas ,table1[Type] = 911)  , "Emergency",IF(AND(table1[location] = "New York", table1[Type] = "Non 911"),"Non-Emergency"))

Hope this help

Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com

[umanbr · Accepted solution]

Try this:

NewColumn = SWITCH(true(),'Table'[state]="tx"&&'Table'[type]="911","Emergency",'Table'[state]="NewYork"&&'Table'[type]="911","Non-Emergency","Regular")

[Anonymous · Accepted solution]

Hi

In your table, select Add a new column 

if (AND(table1[location] = Texas ,table1[Type] = 911)  , "Emergency",IF(AND(table1[location] = "New York", table1[Type] = "Non 911"),"Non-Emergency"))

Hope this help

Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com

[cwnoll]

thank you very much... as usual i try and over complicate things