Change the starting date of a year

[elois33]

Hello, 

I have the following DAX for an automated calendar: 

Calendar=

ADDCOLUMNS(

CALENDARAUTO(),

"year", YEAR([Date]),

"month",FORMAT([Date],"MMMM"),

"month year", FORMAT([Date],"MMMM YYYY"),

"day of week",FORMAT([Date],"dddd"),

"day", DAY([Date])

)

I want to change the starting date of my calendar-year in a way that each year will not start in the 1 january but earlier in december (like 11 or 15). I there anything that I can do?  Thank you! 

[v-jialluo-msft]

Hi  @elois33 ,

You can try this:

CALENDAR = ADDCOLUMNS(

CALENDAR(date(2022,1,1),date(2022,12,31)),

"YEAR",YEAR([Date]),

"QUARTER",ROUNDUP(MONTH([Date])/3,0),

"MONTH",MONTH([Date]),

"WEEKNUM",WEEKNUM([Date]),

"YEAR-QUARTER",YEAR([Date]) & "Q" & ROUNDUP(MONTH([Date])/3,0),

"YEAR-MONTH",YEAR([Date])*100+MONTH([Date]),

"YEAR-WEEK",YEAR([Date])*100+WEEKNUM([Date]),

"WEEKDAY",WEEKDAY([Date])

)

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[elois33]

Thank you @amitchandak for this helpful post! Indeed very interesting! I was looking if there is a way to make it easier to modify because we chang the starting date every year. So I was hoping finding something with DATESBETWEEN where my colleuges can have easily access and modify if any need. For example IF(DATESBETWEEN(Calendar[year],11/12/2022,11/12/2023), "S2023"

IF(DATESBETWEEN(Calendar[year],12/12/2023,13/12/2024), "S2024"

Thank you!

[amitchandak]

@elois33 , refer if these two can help

https://medium.com/chandakamit/cheat-sheet-calendar-that-starts-with-any-date-of-the-month-just-two-...

https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5e...