I am not able to filter just the right Yr-Week for last complete Amazon week (for ex. Wk 3 23) and also to select only one column to leave YoY(Bps) Calculation is correct but cannot filter and display nicely the right one single period. https://us-east-1.quicksight.aws.amazon.com/sn/dashboards/8bc4f2…

Maybe something like: [image] Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc) Articles Often you may want to create tables and other visuals which display multiple fields that are all ‘filtered’ to different date periods, as …

Hi @lrromans maybe you can have a look at. [image] Creating period comparisons with QuickSight's periodOver and periodTo functions Articles This article uses the SaaS-Sales Dataset that you can download as part of the QuickSight Author Workshop . We will update the data to…

Hi @lrromans could you found a solution? BR

No I would like to explore further. I am interested in YOY when complete weeks are compared. For ex week 5 24 versus week 5 23. Please let me know if you have a useful link.

YOY clean visual in Quicksight

Q&A

ErikG January 25, 2024, 6:43am 2

Hi @lrromans
maybe you can have a look at.

Topic		Replies	Views
Creating period comparisons with Quick Sight's periodOver and periodTo functions Technical Articles error , calculations	32	25429	November 21, 2024
Error periodOverPeriodLastValue periodo week Q&A analysis , feature-request , quick-sight , calculations	5	535	April 3, 2023
Comparing a specific week to the corresponding week of the previous year Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	5	94	July 30, 2025
YOY data with pre-set date range filters Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	16	241	August 22, 2024
Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc) Technical Articles yoy , date , period-over-period , quick-sight , calculations , Business-Intelligence-Engineer	103	38388	November 24, 2025

YOY clean visual in Quicksight

Related topics