QTD for Fiscal Year Ending August 31

[alvinyongck]

What is the best way to calculate QTD for fiscal year ending August 31. The default QTD only works with quarters ending in March, June, Sept and December

[themistoklis]

@alvinyongck 

The following link will help you.

https://www.daxpatterns.com/custom-time-related-calculations/#

It creates a custom date calendar using a DAX formula.

You specify on the top the first fiscal month + you can customise all time dimensions