Custom column - 2 columns condition

[Anonymous]

Hello,

Im trying to add a custom column that taked 2 conditions from 2 different colums in the same table.

I tried using IF function but it returns this error "Expression.Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly."

This is what i tried - 

IF([Event]="X" & [EventName]="Y",0,1)

The reason is to be able to sum up the colum with edit query.

Thanks!

[amitchandak]

@Anonymous , Try &&

IF([Event]="X" && [EventName]="Y",0,1)

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

if is lower case in Power Query. 

What you need is 

if [Event] = "X" and [Eventname] = "Y" then 0 else 1

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Anonymous]

Hi!

Thanks a lot, that did the trick.