Forum Discussion
RSCustomDaxFilter column name with square brackets
- 1 year ago
Hi Max_WH ,
Thank you Aala_Ali for the workaround suggestion.
You're absolutely right to dig into escaping syntax, but unfortunately, RSCustomDaxFilter does not support escaping nested square brackets within column names. The parser expects a clean [Table].[Column] format, and any additional brackets inside the column name will break validation.
Unlike DAX or M expressions where certain escape sequences might be allowed, RSCustomDaxFilter is a custom expression used in paginated reports and doesn’t offer a way to escape or quote complex column names. It treats square brackets as structural delimiters, not literal characters.
Warm Regards,
Chaithra E.
Thank you!
Yes, that's RSCustomDaxFilter definition itself.
But would like to know if there is anyway to escape the column square brackets in the formula....
Hi Max_WH ,
Thank you Aala_Ali for the workaround suggestion.
You're absolutely right to dig into escaping syntax, but unfortunately, RSCustomDaxFilter does not support escaping nested square brackets within column names. The parser expects a clean [Table].[Column] format, and any additional brackets inside the column name will break validation.
Unlike DAX or M expressions where certain escape sequences might be allowed, RSCustomDaxFilter is a custom expression used in paginated reports and doesn’t offer a way to escape or quote complex column names. It treats square brackets as structural delimiters, not literal characters.
Warm Regards,
Chaithra E.