Custom Column: token literal expected

[Anonymous]

Hi group,

I am creating a new column in Power Query using 2 existing columns: sessions and boucnes. Both are numeric.

For new custom column I wrote: if ([sessions]=1 && [bounces]=1,1,0)  I am trying to give the new column value=1 when bouth sessions and bounces are 1. 

However I am getting this error: token literal expected, does anyone know how I could optimize the formula? Thanks!

[AlexisOlson · Accepted solution]

In M (it's not DAX), you'd write that if statement as follows:

if ([sessions] = 1) and ([bounces] = 1) then 1 else 0