Extended Calendar/Date Table WeekNumber

[Melissa]

Hi @cs566,

Instead of the Extended Date table please consider switching to the Basic Date table, among other things this allows you to set the start of week day…

Basic Date Table (Power Query M function)

Hi all, There have been requests for a basic Date table that includes week logic centered around the start- / end of week dates AND/OR fiscal weeks. Both will start on the selected Start of week day but the first creates weeks of 7 days when crossing over into the next calendar year and the second weeks with <= 7 days around each fiscal year start and -enddate, as illustrated below. . [image] . Copy this M code script into a new blank query. let fnDateTable = (StartDate as date, EndDate …

Note that the Extended Date table is an ISO-8601 type calendar, which requires Monday to be the first day of the week.

I hope this is helpful