Forum Discussion
Power query if statement help
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.
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
3 Replies
Anonymouscan you try it like this
if ([Index]=1 and [val]<>null) then 1 else if ([Index]>1 and [val]<>null) then 2 else 0Anonymous , 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
