Hello, I am trying to get to a certain YOY value, and think there is an easier way to get to it than I am thinking. I am a Power BI user so I am trying to just ‘transfer’ the same logic from Power BI to QuickSight. I need to display YOY %s in a KPI visual up to a certain date. I have the correct f…

Hi zwaters! Sorry for the delay. You are using table calculations (periodOverPeriod, etc), which as you correctly pointed out require the prior period data to be part of the query/visual (which is why you cant filter it out). This approach might not work for you table where you show each month, b…

How to calculate YOY % through certain date?

Q&A

Jesse June 9, 2022, 4:08pm 4

Hi Zenia - I answered your question over here: Period Over Period Functions with Date Controls - #3 by Jesse

Topic		Replies	Views
Period Over Period Functions with Date Controls Q&A calculations	14	4249	October 2, 2023
YoY formula not working when filtering out last year's data Q&A admin , quicksight , reports , qls-reporting	1	369	January 16, 2024
Illustrate YoY Growth Rates and hide original values Q&A calculations , Business-Intelligence-Engineer	4	45	August 27, 2024
YOY KPI with date selection parameter Q&A analysis , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	4	854	December 21, 2023
KPI metric values Q&A formatting , calculations , how-to	3	1528	January 11, 2023

How to calculate YOY % through certain date?

Related topics