Set analysis

[xavier2024]

formula to compare the same period of this year vs last year - my year is 2023 and i want to compare sales in 2023 January 22 with the sales made in 2024 January 22

[MayilVahanan]

Hi

Try like below, it wil give last year same day

=Sum({<Date={"$(=AddMonths(Max(Date),-12))"}>}Sales)

[xavier2024]

How can i edit the above formula to get a % change in the sales for 2023 upto 01-22 with the sales for 2024 upto 01-22

[Rohan]

Hi @xavier2024 ,

try this :

CY - YTD : Sum({<Date={"<=$(=date(yearstart(max(Date)))) <=$(=date(max(Date)))"}>} Sales)

PY - YTD : Sum({<Date={"<=$(=date(yearstart(max(Date),-1))) <=$(=date(addyears(max(Date),-1)))"}>} Sales)

Regards,

Rohan.

[Chanty4u]

Try this

(Sum({<Date={">=$(=YearStart(Max(Date), -1)) <=$(=Date(Max(Date)))"}>} Sales)

- Sum({<Date={">=$(=YearStart(Max(Date), -2)) <=$(=Date(Max(Date), -1))"}>} Sales))

/

Sum({<Date={">=$(=YearStart(Max(Date), -2)) <=$(=Date(Max(Date), -1))"}>} Sales)