Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
While computing measure "previous month ", we are using the below formula
Sum({<[REPORTING_DATE]={">=$(=MonthStart(Addmonths(([REPORTING_DATE]),-1)))<=$(=MonthEnd(Addmonths(([REPORTING_DATE]),-1)))"}>}REPORTING_AMOUNT)
Also tried with autocalender function:
Sum( { $< [Date(REPORTING_DATE).autoCalendar.MonthsAgo]={1} > } [REPORTING_AMOUNT] )
Still its giving the values for current month only.
Please help!
Hi there.
Considering your date field is correctly formatted, try this out:
Sum({<[REPORTING_DATE]={">=$(=MonthStart([REPORTING_DATE],-1))<=$(=MonthEnd([REPORTING_DATE],-1))"}>}REPORTING_AMOUNT)
As you can see, second parameter either MonthStart and MonthEnd is period number.
Hope it helps you.