Calculate column

[Anonymous]

How can i create calculate column with IF statement ?

[az38]

hi @Anonymous 

try

= if [ZIPCH037].[LEVEL01].[MEMBER_CAPTION] <> "План ГПКЗ"  then 1 else 0

[Anonymous]

I tried but already another exception

[Mariusz · Accepted solution]

Hi @Anonymous 

Your Column names contain "[" and "]" characters and this is reserved for defining a column in M, so you need to wrap your column in [#"[your column]"] and this should clear the error.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[Anonymous]

Thanks!

[az38]

so, @Mariusz gave you a correct solution

[Mariusz]

Hi @Anonymous 

Remove "(" and ")" 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.