Restrict the months in dimension filter

[eddywong71]

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.

[MatheusC · Accepted solution]

@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