problem with m formula

[Giada90]

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

[DOLEARY85 · Accepted solution]

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

[Giada90]

THANKS!