topic Re: If statement in order to create new column in DAX Commands and Tips

If statement in order to create new column

Anonymous — Fri, 29 May 2020 01:33:34 GMT

I have table that looks like this:

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

mahoneypat — Fri, 29 May 2020 01:29:56 GMT

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 — Fri, 29 May 2020 01:48:47 GMT

Hi mohoneypat,

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

Anonymous — Fri, 29 May 2020 04:54:11 GMT

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)