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.
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.
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |