How to restricted last 13 month data in filter

[lakshman1031]

Hi All,

I have Date field and in that date having MMM YYYY format.

I have take this date filed in to filter. My date field having last 5 years data but i want to see last 13 months data in filter.

Can you please suggest me how to do in this scenario.

Thanks & Regards,

Lakshman

[Kushal_Chawda · Accepted solution]

@lakshman1031  If your Month is formatted as Numeric, you can try below expression in filter. If it is text you need to make it in Numeric format with date(Date#(Month,'MMM YYYY'),'MMM YYYY') as MONTH in load script

aggr(only({<MONTH ={">=$(=date(addmonths(max(MONTH),-12),'MMM YYYY'))<=$(=date(max(MONTH),'MMM YYYY'))"}>}MONTH),MONTH)