Compare current week, same week in last month and same week in last year

[ErikG]

Hi @Ren
maybe you can have a look at:

Creating period comparisons with QuickSight's periodOver and periodTo functions

This article uses the SaaS-Sales Dataset that you can download as part of the QuickSight Author Workshop. We will update the data to the current date so your calculations are realistic. If you do not have a QuickSight account please follow the instructions in the Initial Setup. Instructions to create the dataset can be found in Exercise 1 of the Build your first dashboard. Create an analysis for the dataset. The following steps show you how to create visuals to show data from the current year,…

and

Previous Year YTD Aggregation functions

Hi team, Background in my analysis, I want to compare current year YTD revenue v.s. 2022 YTD revenue, in which I need 2023 Jan-March revenue data v.s. 2022 Jan-March revenue data. I need to calculate dynamic YTD revenue for previous year (2022). I used this function:periodToDateSumOverTime(sum(ddc), {calendar_date}, MONTH). This formula turns out to the correct numbers but it gave me more month’s data than I expected. I only want 2022 revenue data from Jan - March. Could anyone pls advice sol…

BR