Forum Discussion
Can IF statement follow by calculation?
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.
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
2 Replies
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
Jimmyhmm, yeah, I don;t know why it show error back then, but now is ok
Ok, thanks for comfirming.
