I have a pivot table with weekly columns stretching back for three years. Within this table, I am trying to use 'Show Column If' to dynamically show only the last seven weeks of activity. Normally I would use set analysis to limit the measures to certain a data range, but for other reasons, that's not ideal. I have tried using...
weekstart(PTArrivalDate)>= '2021-10-01'
weekstart(PTArrivalDate)>= today()-49
...but neither of these makes any difference in the table.
What you're trying to do won't work, unfortunately. Show/hide column is evaluated once, for the entire column. It is not evaluated for each specific dimension value.
What you're trying to do won't work, unfortunately. Show/hide column is evaluated once, for the entire column. It is not evaluated for each specific dimension value.
