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 Quick Sight. I need to display YOY %s in a KPI visual up to a certain date. I have the correct …

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	4462	October 2, 2023
YoY formula not working when filtering out last year's data Q&A admin , reports , qls-reporting	1	391	January 16, 2024
Illustrate YoY Growth Rates and hide original values Q&A calculations , Business-Intelligence-Engineer	4	73	August 27, 2024
YOY KPI with date selection parameter Q&A analysis , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	4	919	December 21, 2023
YOY calculation got errased Q&A calculation , calculations-editor , calculated-field , calculations , Business-Intelligence-Engineer	3	94	November 16, 2024

How to calculate YOY % through certain date?

Related topics