Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 tr...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

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

    if ([sessions] = 1) and ([bounces] = 1) then 1 else 0
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

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

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