Month to Month comparison from this year to previous year

Hi @P_G ,

Here’s a sample dashboard that shows how you can compare period to date measures across years.
You can click the copy analysis icon on this page to create a copy of the underlying analysis and explore the solution therein.
I have used 15-Nov-2023 as current date in this sample as this is going against a static dataset. In real life scenario, you will use now() to get the current date.
Q23696 Solution

More on Arena - QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community

Regards,
Arun Santhosh
Pr QuickSight SA