If statement in order to create new column

[Anonymous]

I have table that looks like this:

id	Actityvity	Device
1	Relax	Mobile
2	Hyper	PC
3	Laid Back	Mobe
4	Relax	Mobile
5	Hyper	PC
6	Laid Back	Mobile

I'm trying to create a new caloumn by applying the If statement in Dax, to say: IF Activity = Relax And Device= Mobile Then 1.

What the best way to go about it.

Thanks

[harshnathani · Accepted solution]

Hi @Anonymous ,

Create a New Column

New Column = SWITCH(

TRUE(),

'Table'[Actityvity] = "Relax" && 'Table'[Device] = "Mobile",1

)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[mahoneypat]

Are you trying to make a calculated column or a measure?  If a column, you can use this expression (substitute the name of your table for 'Table')

NewColumn = if(AND(Table[Activity]="Relax", Table[Device]="Mobile"), 1, 0)

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

Hi mohoneypat,

unfortunately, using this dax isn't recognizing my table.