Greetings! I have been trying to replicate my organization’s visualization assets into Quick Sight from Power BI as we are exploring a shift and this particular calculation is proving to be difficult. As visible, the bar chart is comparing monthly transactions with the transactions for the same mon…

Hey @vkedia , welcome to the Quick Sight Community :partying_face:. In your situation you can’t filter for that specific timerange - in your example you only access data from 2024/01/01 till 2024/05/21 everything else is ignored. You need to use parameters in a calculation. I think @Jesse answere…

For some reason Quick Sight won’t allow me to put two sceenshots so here’s the Quick Sight visual for reference: [image]

Current Year vs Previous Year Calculation

Q&A

ArunSanthosh May 24, 2024, 3:36pm 4

Hi vedant @vkedia ,

I’m marking Robert’s (@robert.eibers) response as the solution.
Please let us know if you are still facing issues and include an Arena sample as suggested in last response.

Regards,
Arun Santhosh
Pr Quick Sight SA

Topic		Replies	Views
Navigation action using date parameters Q&A interactivity , filters , parameters , quick-sight , Business-Intelligence-Engineer	23	1135	December 8, 2023
Creating period comparisons with Quick Sight's periodOver and periodTo functions Technical Articles error , calculations	32	25161	November 21, 2024
How to calculate YOY % through certain date? Q&A quick-sight , calculations	3	5470	June 9, 2022
Get previous year value with additional filters applied Q&A filters , quick-sight , calculations , Business-Intelligence-Engineer	5	123	December 14, 2024
Can I have the sum of sales for selected year (by user) from the date filter and sum of sales for its previous year as well in bar chart? Q&A filters , parameters , quick-sight , calculations	3	389	July 6, 2023

Current Year vs Previous Year Calculation

Related topics