Forum Discussion

Giada90's avatar
Giada90
Helper IV
3 years ago
Solved

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

2 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar

    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