I’m trying to create a calculated row using values from rows A, B, and C. The calculation should be A (current year) / B (prior year) * C (prior year). Is there a way to look up the prior year values for the calculation? [image]

Hi @Quick SightLover You can use periodOverPeriodLastValue in combination with aggregations. periodOverPeriodLastValue(sum({arrival_timestamp_int}),{arrival_timestamp},MONTH,1) + sum({arrival_timestamp_int}) You would just need to separate this out with if statements depending on your service_typ…

Lookup Values from Previous Year

Q&A

SD_QS May 26, 2023, 5:43pm 2

Hi @Quick SightLover Welcome to the Quick Sight community

Does this answer your question: Is there a way to add a 'Row' calculated field? ?

Topic		Replies	Views
How to create calculate field to fetch previous value in column? Q&A quick-sight , calculations	1	1108	February 4, 2023
Previous period comparison with a filter on date does not work Q&A analysis , filters , period-over-period , quick-sight , calculations , how-to	3	590	July 24, 2023
I would like to be able to calculate the value of a measure from the previous month Q&A quick-sight , Business-Intelligence-Engineer	4	139	May 8, 2024
Row context to calculate WoW, YoY, PoP Q&A quick-sight , calculations	5	4872	October 26, 2021
Calculation compared to the same period of the previous year Q&A quick-sight , calculations	2	1200	September 11, 2023

Lookup Values from Previous Year

Related topics