Hi everyone, I have to create a calculation to set the current value of a measure. based on the following input. [image] Here active headcount is pulling from db as of now Selected Month is Aug 2024, which is a parameter and the visual displays next 12 months of selected month. Hires= hires(pul…

Hi @ArunSanthosh I was able to get the calculation using Lag function.

Hi, Try this document, hope this will work for you. periodOverPeriodLastValue - Amazon QuickSight Use the periodOverPeriodLastValue function for calculated fields in Amazon QuickSight analyses. Regards, Naveed Ali

Hi, Just look at solution, may be you get some help from it. [image] Calculated field to pull only a measure's latest monthly value when selecting multiple months Question & Answer Hi @Diego - You can use this approach. You can consolidate some of the calcs if needed bu…

Hi @Naveed , @WLS-DM I tried that approach, but its not working in my case. may be something wrong with the calculation. But I am sure, this wont be enough for me I need to satisfy the following criteria’s to get a proper calculation For the First month in the visual, I need to check what is the…

Hi all, Is there any update on the above question? I have been trying different types of calculations to get the previous month expected ending count as next month active for past 1 week. But cant see any improvement. Can anyone help please!!!

Hi @Ganga , Glad to hear that you are unblocked :slight_smile: Regards, Arun Santhosh Pr Quick Sight SA

Calculation to set the previous month's total as current month actual value

Q&A

ArunSanthosh August 6, 2024, 9:42pm 6

Hi @Ganga,

When you need help with calculations, our recommendation is to create a sample in Arena. This will improve your chances of getting help from the community.

Regards,
Arun Santhosh
Pr Quick Sight SA

Topic		Replies	Views
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	178	May 8, 2024
How to get difference value and the end-of-month values Q&A date , quick-sight , visuals , calculations , Business-Intelligence-Engineer	3	750	October 31, 2023
Sum of current month till date i.e. max of date in data same for Previous months Q&A date , quick-sight , calculations , Business-Intelligence-Engineer	1	141	June 3, 2024
Making the count at the end of the month = the count at the beginning of the next month Q&A quick-sight , calculations	5	510	July 12, 2023
Exisitng rows as derrived column Q&A date , quick-sight , calculations , Business-Intelligence-Engineer	3	143	February 6, 2024

Calculation to set the previous month's total as current month actual value

Related topics