Year to date, Quarter to date Calc in QuickSight

[Giridhar.Prabhu]

Hi @mppeciak

Welcome to the QuiclSight community.

You may need to create a calculated field to get a date value based on your Year and Period.

Refer to the ParseDate for the same

parseDate - Amazon QuickSight

The following article has all the details for how to compute the YTD, QTD.

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Hi @Jesse I am using 2 parameters ( paramAsOfYear and paramAsOfMonth ) to compute relevant calculated fields prefixed with @. Pivot table is created as below and figures are correct. [image] However, the column header is showing the calculated field name. How can I change to those in red font. [image] Using “Value names”, we can specify the parameter field but unable to perform any computation on parameter field e.g. paramAsOfYear-1 [image] Using name like “Previous Month” may not work…

Hope this helps.

Regards,
Giri