Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Hasvine2022
Helper I
Helper I

Calendar - Week number has incorrect start date

Hello Team,

 

Hope you are fine.

 

I am trying to add a week number in my calendar using the below:

 

Calendar = ADDCOLUMNS(CALENDAR(Date(2021,10,01), date(2030,12,31))
,"Month Year", Format([Date], "MMM-YYYY")
,"Month Year sort", Format([Date], "YYYYMM")
,"Year", Year([Date])
,"YYYY-WK", FORMAT([Date],"YYYY-WW")
,"Qtr Year", Format([Date],"YYYY\QQ"))
 
However, the start date for the week is incorrect as it starts on a Sunday:
 Hasvine2022_0-1661333922197.png
 
Do you have an idea on how to resolve it?
 
Thank you.
 
Kind Regards,
 
1 ACCEPTED SOLUTION
keshavagrawal27
Resolver I
Resolver I

Hi @Hasvine2022 ,

Try below:

Calendar = ADDCOLUMNS(CALENDAR(Date(2021,10,01), date(2030,12,31))
,"Month Year"Format([Date]"MMM-YYYY")
,"Month Year sort"Format([Date]"YYYYMM")
,"Year"Year([Date])
,"YYYY-WK", Concat(FORMAT([Date],"YYYY"),WeekDay([Date],2))
,"Qtr Year"Format([Date],"YYYY\QQ"))
 
Please mark it as a solution if it satisfies your requirement 🙂

View solution in original post

1 REPLY 1
keshavagrawal27
Resolver I
Resolver I

Hi @Hasvine2022 ,

Try below:

Calendar = ADDCOLUMNS(CALENDAR(Date(2021,10,01), date(2030,12,31))
,"Month Year"Format([Date]"MMM-YYYY")
,"Month Year sort"Format([Date]"YYYYMM")
,"Year"Year([Date])
,"YYYY-WK", Concat(FORMAT([Date],"YYYY"),WeekDay([Date],2))
,"Qtr Year"Format([Date],"YYYY\QQ"))
 
Please mark it as a solution if it satisfies your requirement 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.