Forum Discussion
Calculate column
How can i create calculate column with IF statement ?
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.
hi Anonymous
try
= if [ZIPCH037].[LEVEL01].[MEMBER_CAPTION] <> "План ГПКЗ" then 1 else 0I tried but already another exception
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.- Thanks!