Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Using below am getting last year Last month sale (28-FEB-16) but am not getting 29-feb-16 day of sale.
What i want to make changes in this
Thanks
Try like (change highlighted in red):
(SUM({$<FinancialYear=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)},Quarter=
,[Posting Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))<=$(=MonthEnd(addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12)))"}
>}[Gross Sales Amount])
to get 29 feb 16 you have to use MonthEnd().
for better understanding share sample data and required output.
Try like (change highlighted in red):
(SUM({$<FinancialYear=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)},Quarter=
,[Posting Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))<=$(=MonthEnd(addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12)))"}
>}[Gross Sales Amount])