Hi all, pretty easy use case in quicksight, but cannot manage to solve it: I have a “delta to target” column and a “accounting year” column. “delta to target” = decimal “accounting year” = dates throughout the year __________________________________________________________________ In a table …

Hi @eddie1995 , To use your formula with a parameter control for dynamically selecting different reporting months, create a date parameter called ReportingMonthEnd. Then update your formula to ifelse(dateDiff({Accounting year}, ${ReportingMonthEnd}, “MM”) = 0, {Cumulative spend},0 ) Since you’re…

Hi @eddie1995 , Nice seeing you back in the Quick Community! Just to make sure I fully understand your question, are you looking to retrieve the difference between Jan-Dec compared to Jan-Nov (which would just be the the sum of December)? Let me know if I misunderstood anything and please feel free …

Hey, thank you for your answer! Almost. What I’m trying to calculate is the percentage difference between the cumulative total from January to November and the cumulative total from January to December. For example: The sum from January to November is 10,000. In December, we add another 2,000, br…

Hi @eddie1995 , Just checking back in since we haven’t heard from you in a bit. I wanted to see if the guidance shared earlier helped resolve your question, or if you found a solution in the meantime. If you still have any additional questions related to your initial post, feel free to share them. …

Hi, Thank you for rechecking & sorry for the late response (just returned from vacation). I went through the guidance. This will kind of work, but I’m facing another issue: I want to use a parameter to replace “now()” in a month-to-date formula. I would like to use this as a control to be able to…

To make it easier: Im looking for a solution to use this formula with a control filter to provide a filter to select different reporting months. ifelse(dateDiff({Accounting year}, parseDate(‘2025-12-31’, ‘yyyy-MM-dd’), “MM”) = 0, {Cumulative spend}, 0)

periodOverPeriodPercentDifference MoM

Q&A

Giridhar.Prabhu December 29, 2025, 6:30am 4

Hi @eddie1995

You may need to do apply your data checks in the calculated fields and not apply the date filters on the visual to achieve this.

See if this article helps

Regards,
Giri

Topic		Replies	Views
Hide the first periodOverPeriodDifference Value in a visual sheet Q&A quick-sight , filters-controls-and-parameters , visual , Business-Intelligence-Engineer	9	121	July 5, 2025
Using periodOverPeriodPercentDifference in a monthly dashboard Q&A quick-sight , visuals , calculations , Business-Intelligence-Engineer	3	100	June 21, 2024
PeriodOverPeriodComparison - Desenvolvimento QuickSight Q&A analysis , error , quick-sight , dashboard , calculations , Business-Intelligence-Engineer	2	39	November 19, 2025
periodOverPeriod calculations not showing in the Totals for Columns Q&A analysis , period-over-period , quick-sight , pivot-table , Business-Intelligence-Engineer	5	449	August 15, 2024
Period on period calculations donot show in Total field Q&A period-over-period , feature-request , quick-sight	3	327	July 11, 2023

periodOverPeriodPercentDifference MoM

Related topics