Forum Discussion
FY Starting in April
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
1 Reply
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
