Robert Williams on 04 Oct 2019 15:42:33
Hello,
When you use CALENDARAUTO () you have the option to supply your financial year end month, so CALENDARAUTO(3) for march.
However when a date hierarchy is created on your date table the quarters are still based on the jan-dec values.
Clearly, if I set my financial beginning of the year as April, then April-May-June are the first quarter, not Jan-Feb-March as the auto date hierarchy creates it.