Creating Calculated Fields for multiple custom date filters in one visual

[andres007]

Hello @aheverett,

Have you checked this previous solution from the community?

Change Calendar to Fiscal Year

Hi, I use Quicksight Embedded to help analyze sales data for my customers. The biggest issue I’m experiencing is that most of my customers do not use January - December as their fiscal year. Many will use Feb - Jan. There are two specific problems I’m experiencing: All the QoQ, YoY, YTD calculations won’t work, and The “Relative Date” filter, which I use everywhere doesn’t work because it assumes “Last Quarter” or “Last Year” is based on Calendar. Is there currently, or on the roadmap any fe…

Let us know if this works