Previous period sum formula

[#1]

Hello everyone,

i have such an issue - there is sales sum in several months and i need to get previous period sum (in that case previous month) while selected one certain month. I have tried about 5-6 formulas and no one works, for example:

Sum({$<Month={"$(=Max([Дата.autoCalendar.Month])-1)"}>}  [Sum] ) - this shows the same sum (selected and previous month), though there is another sum in previous month.

Could anyone help me?

[sunny_talwar · Accepted solution]

Try this:

Sum({$<[Дата]={"$(='>=' & Date(Monthstart(Max([Дата]),-1), DD.MM.YYYY') & '<' & Date(Monthstart(Max([Дата])), DD.MM.YYYY'))"}, [Дата.autoCalendar.YearMonth]>}  [Sum] )

[#3]

it works! thanks a lot.