Forum Discussion
Giada90
3 years agoHelper IV
problem with m formula
Hi,
I need to create a column in power query editor, I need to use an if function and I need to moltiplicate the result, I try a formula like this but it gives me error when I try to moltiplicate
(each if [#"What_relationship"] = "Neutral" then 1 else if [#"What_relationship"] = "Not satisfied" then 2 else 0)*2
if I try to use the if column (called personalizzato) and I use this formula it works
[Personalizzato.1]*2
any suggestion?
Thanks
just remove the each at the begining.
try this in the custom column formula:
(if [#"What_relationship"] = "Neutral" then 1 else if [#"What_relationship"] = "Not satisfied" then 2 else 0)*2