FY Starting in April

[RBettinelli]

hello

I have used the attached code to create a date table that helps me to sort and graph multiple years of fin data on one line chart. I just cant figure out what I need to change on it though, to get my Financial year adn Quarters to start on April 1st. I have attempted to edit and end up breaking the who thing.

MyFY2012DatesTable =

VAR myExtendedCalendar = ADDCOLUMNS(

            CALENDAR(DATE(2012,3,1),DATE(2013,3,31)),

            "Year", YEAR([Date]),

            "MonthNumber", MONTH([Date]),

            "DayNumber", DAY([Date]),

            "Month", FORMAT([Date],"mmmm"),

            "DayOfWeek", FORMAT([Date],"ddd"),

            "DayOfWeekNumber", WEEKDAY([Date]),

            "QuarterNumber", QUARTER([Date]) ,

            "Quarter", FORMAT([Date],"\QQ"),

            "WeekNumber",WEEKNUM([Date]),

            "MonthDayKey",FORMAT([Date],"mmm-dd")

            )

VAR myExtendedCalendarWithDayOfYear = ADDCOLUMNS(

            myExtendedCalendar,

            "DayNoOfYear",

            DATEDIFF ( DATE ( YEAR ( [Date] ), 1, 1 ), [Date], DAY ) + 1

            )

return myExtendedCalendarWithDayOfYear

Thanks

[Greg_Deckler]

@RBettinelli You could use this: Extended Date Table (Power Query M function) - Power Query / M Code Showcase - Enterprise DNA Forum

Or I created a DAX 445 that can start whenever. (1) DAX Custom 445 Calendar - Microsoft Fabric Community