Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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