Restrict the months in dimension filter

eddywong71 — Tue, 16 Jul 2024 07:15:29 GMT

Hi Anyone,

May I ask how to create a Month filter no affect the back end data.

For example ,I have 2 Year data (202201-202312). I want to create a filter the user only can choose(202301-202312).

The filter as below expression.

If( Date#(Month,'YYYYMM') <= Date(MonthStart(vMaxMonthYear,0) ,'YYYYMM')
AND
Date#(Month,'YYYYMM') >= Date(MonthStart(vMaxMonthYear,-11) ,'YYYYMM')

, Date(Month,'MMM YY'))

However, this expression let the user can't access all the data from (202201-202212) which is not I want . It is because I have some YTD Comparison and past year chart.

I just want to limit user choosing the filter only.

Re: Restrict the months in dimension filter

MatheusC — Tue, 16 Jul 2024 20:38:46 GMT

@eddywong71

Are these two range periods bringing the correct periods? With the Year/Month date formatted,
try this:

aggr(Only({< DateMonth ={ ">=$(=Date(MonthStart(DateMonth,-11) ,'YYYYMM'))<=$(=Date(MonthStart(DateMonth,0) ,'YYYYMM'))" }>} DateMonth),DateMonth)

- Matheus

topic Restrict the months in dimension filter in App Development

Restrict the months in dimension filter

Re: Restrict the months in dimension filter