Forum Discussion
Anonymous
6 years agoNot applicable
Calculate column
How can i create calculate column with IF statement ?
- 6 years ago
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.
Mariusz
6 years agoCommunity Champion
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.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Anonymous
6 years agoNot applicable
Thanks!