Can IF statement follow by calculation?

[admin_xlsior]

Hi guys,

If I have this table

how to add custom column saying that If [Toggle] = 1 then [Value]/10 else [Value]/10 * -1

I found the If statement only allow a fixed value, is that correct? 

I'm sorry but I never use Power query or M language before.

Thanks.

[Jimmy801 · Accepted solution]

Hello @admin_xlsior 

what you mean by fixed value?

the first parameter you can use also a list or table by applying a function like

if Table.RowCount(YourTable)= 1 then ....

and for the then end else you can use let/in and functions as well like

if [Toggle]=1 then 
let 
   FirstStep = .....,
   SecondStep = FirstStep + 1
in
   SecondStep

else
   null

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[admin_xlsior]

hmm, yeah, I don;t know why it show error back then, but now is ok

Ok, thanks for comfirming.