79277811

Date: 2024-12-13 09:38:52
Score: 2
Natty:
Report link

First of all, the rule of thumb is to stick to a date-based calendar table; secondly, "offset dates" pattern can easily tackle such a fiscal year scenario.

Fiscal Yr-Qtr = FORMAT( EDATE( DATES[Date], 4 ), "yyyy-\QQ" )

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: ThxAlot