Power query if statement help

[Anonymous]

Can someone please help me with the error on the attached picture? It seems as though I'm missing something simple, but can seem to be able to get the syntax right. 

 

[nandic · Accepted solution]

@Anonymous , you have " sign on wrong place (in front of field name).
"[MRP Type]="ND" then ...
it should be
[MRP Type]="ND" then ...

Regards,

Nemanja Andic

[Anonymous]

That was it! Can't believe I didn't catch that. Thank you!!

[smpa01]

@Anonymouscan you try it like this

if ([Index]=1 and [val]<>null) then 1 else if ([Index]>1 and [val]<>null) then 2 else 0