Period Comparisons Based on a Trading Calendar

Question & Answer
1

Hi,

I have a use case that requires period-over-period and period-to-date comparisons based on July to June trading years. An added complication is that the trading period start and end dates don’t always correspond to calendar month starts or ends.

My understanding is that QuickSight bases all its date calculations on calendar years so how do I compare periods based on a trading calendar?

2

You can try and subtract datetimes so that the start of July is actually the start of January.

3

Thanks again, Max.

Apologies for the slow response.

1 Like
4

@terryb Thanks for your reply. Did Max’s response solve your question? If so, could you mark it as Solution by clicking the check box under his reply? That will help the Community out. Thanks so much!

5

Thanks for the nudge, Kristin. I’ve now marked Max’s response as a solution.

1 Like