Hi, I’m trying to create a KPI visual. Instead of comparing, for example, December 2023 revenue with November 2023 revenue, I need to compare December 2023 revenue with December 2022 revenue. How can I do that?

Hi @P_G , Here’s a sample dashboard that shows how you can compare period to date measures across years. You can click the copy analysis icon on this page to create a copy of the underlying analysis and explore the solution therein. I have used 15-Nov-2023 as current date in this sample as this i…

Hi @P_G maybe [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 the current date so your cal…

Hi Erik. Thanks for your help but I’m stacked at point 12: what should I do if my “Sales” is a pre aggregated function? For example imagine that in the function below I would have sum(Sales) instead, and the function wouldn’t work - what can I do instead to make the below work?: ifelse(${PeriodStar…

Hi Arun, thank you so much for your suggestion!

Most welcome @P_G :slight_smile: Regards, Arun Santhosh Pr Quick Sight SA

Month to Month comparison from this year to previous year

Q&A

ErikG January 15, 2024, 8:55pm 2

Hi @P_G
maybe

will help you.
BR

Topic		Replies	Views
Creating period comparisons with Quick Sight's periodOver and periodTo functions Technical Articles error , calculations	32	25298	November 21, 2024
How to compare customize period value Q&A quick-sight	1	491	February 6, 2023
PeriodOverPeriodComparison - Desenvolvimento QuickSight Q&A analysis , error , quick-sight , dashboard , calculations , Business-Intelligence-Engineer	2	39	November 19, 2025
Period to date Computation in Narrative Insights Q&A feature-request , quick-sight , calculations	2	328	May 26, 2023
Getting period-specific calculations on KPI based on date period Q&A analysis , period-over-period , quick-sight , visuals , calculations , Business-Intelligence-Engineer , kpi	8	234	May 15, 2024

Month to Month comparison from this year to previous year

Related topics