'Show Column If' based on Date Range

cfountain72 — Wed, 24 Nov 2021 14:23:08 GMT

Good Morning,

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.

Any suggestions?

Thanks in advance,

Chris

Re: 'Show Column If' based on Date Range

Or — Wed, 24 Nov 2021 14:37:43 GMT

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.

topic 'Show Column If' based on Date Range in App Development

'Show Column If' based on Date Range

Re: 'Show Column If' based on Date Range