Hi! Take a look at this QuickSight Community learning center article (& blog post linked within) to see one approach to implementing period over period calculations.
AWS QuickSight Launched Period function in Jan 2022, providing a powerful out-of-box date-time aware suite of comparative (e.g., year-over-year) and cumulative (e.g., year-to-date) functions. For more details about the period function use cases, refer to this blog post .
Within the suite, Period over Period (PoP) is most frequently used comparative function used to look at two or more measurable events on an annually/quarterly/monthly/weekly basis. Observing PoP performance allows monitoring of …