Previous month selection issue

[saradhi_it]

HI team 

I Have two years of data  From Jan 2018 to Dec 2019,   i got a requirement from the user when the user selects any month filter (list box or filter pane)  data should be calculated from  Mindate to the previous month based on the current selection 

Eg: if user selects  Dec 2019  data should be calculated from Jan 2018(Min date) to Nov 2019 

i tried so many expressions  

COUNT(distinct {<current_Month={"${=Date(MonthStart(max(current_Month), -1),'MMM-YY'))"},Status={'Confirmed '}>} Sales)

I had tried my expressions didn't work 

[PriyankaShivhare]

May be like this:

sum({<Date={">$(=min({1}Date))<$(=addmonths(max(Date),-1))"},Status={'Confirmed'}>}Sales)

or

sum({<Date={"<=$(=addmonths(max(Date),-1))"},Status={'Confirmed'}>}Sales)

or

count({<Date={">$(=min({1}Date))<$(=addmonths(max(Date),-1))"},Status={'Confirmed'}>}Distinct [DimensionField])

Check for the Date format:

Thanks,

Priyanka