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.
6 Replies
hi Anonymous
try
= if [ZIPCH037].[LEVEL01].[MEMBER_CAPTION] <> "План ГПКЗ" then 1 else 0Hi 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
Remove "(" and ")"
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
