Forum Discussion
Custom Column: token literal expected
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!
In M (it's not DAX), you'd write that if statement as follows:
if ([sessions] = 1) and ([bounces] = 1) then 1 else 0
1 Reply
In M (it's not DAX), you'd write that if statement as follows:
if ([sessions] = 1) and ([bounces] = 1) then 1 else 0