How to refer to the columns with [] in the name?

In the table with the revenue data, I do have columns, including [] in the name: [R] F2023, [R] F2024, [R] F2025

How to refer to these columns in the SELECT statement?

I was trying something like this: 

ANY((SELECT(Revenue[[R] F2023], [Product]=[_THISROW].[Product])))

but it doesn't work.

0 2 77
2 REPLIES 2

You don't. Don't use square brackets in your column names. And in general, don't use any special symbols.

Thank you for your prompt reply. I do understand by this that there is no way to deal with such a column. Unfortunately, I'm not able to change the name of the column in the data source, but I have added new columns with the "right" name mapped to the original columns.

Top Labels in this Space