Calculation for previous month is not working

[nipun]

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!

[Thiago_Justen_]

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.