Extended Calendar/Date Table WeekNumber

[cs566]

Hi,
I am utilizing Melissa’s extended data table query. I am wanting to represent the first day of the week to be Sunday. I am unable to revise code to do this. Any suggestions or help would be greatly appreciated.
tks/

[pranamg]

@cs566 - Use Date-DayofWeek specifying Sunday as the Optional firstDayOfWeek parameter.

Date.DayOfWeek(#date(2011, 02, 21), Day.Sunday)

Refer to this blogpost for details. Hope this helps!

[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

[cs566]

Thank you very much!
Now my question is code to calculate CURRENT WK# and PREV WK#. I have tried by following Brian Julius’ post [https://blog.enterprisedna.co/get-power-bi-previous-week-values-using-dax-power-query/], but the PREV WK# shows same number.
Any help would be greatly appreciated.
tks/

[cs566]

Thanks so much… I was able to incorporate in Extended date table, but decided to use the basic date table. Very helpful.