Hi @Rodger, besides using custom SQL – I’m out of ideas. Check out some of these calculations: Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc) and table-calculation-functions documentation.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc) | 103 | 37837 | November 24, 2025 | |
| PeriodOverPeriodComparison - Desenvolvimento QuickSight | 2 | 30 | November 19, 2025 | |
| 指定期間と同じ日数の過去期間における売上集計方法について | 4 | 167 | November 11, 2024 | |
| Creating period comparisons with Quick Sight's periodOver and periodTo functions | 32 | 25124 | November 21, 2024 | |
| Calculation to set the previous month's total as current month actual value | 7 | 601 | August 7, 2024 |