'How to filter by fiscal months in Microsoft SQL Server?

I am looking to filter out or create a new column that segments my data into fiscal month. I have a table like the one pictured below.

Every fiscal month begins on the 26 and ends on the 25 day. (ex: 1/26/21 - 2/25/21)

I want to count the total numbers for each fiscal month vs calendar month. What's the best way to do this?

enter image description here

sql-servertsql


Solution 1:[1]

You should check out this StackOverflow question.

From that it seems like you'd have to create a custom date range for the fiscal month and then a window partition to group on items within the date range.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Parker.V

Related Questions