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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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