Change Day in The Week Number to 1 for Sunday through to Saturday = 7

[DarrenG]

Hi,

Is it possible to have Sunday set as Day Number 1 (Use 1 to 7 instead of 0 to 6)

My working week is Sunday through to Saturday for the whole company (As a complete week)

What would I need to change in the M Code or would I need to manipulate this in a calculated column?

Power BI Date Table code.txt (2.8 KB)

Thanks Darren

[Greg]

Hi @DarrenG. See @Melissa 's Extended Date Table.

Extended Date Table (Power Query M function)

Hi everyone, To make it easier to find I’ve placed the updated Power Query M code function for the extended Date Table / Dates Table in the category where it belongs… I hope you’ll find it useful and if there are any questions, just reach out and let me know! // August 2022 There has been an overhaul of the M code from when it was initially shared. This affects column names and values. In the Analyst Hub (follow this link) you can copy a version of Extended Date table which returns a r…

[Melissa]

Hi @DarrenG,

is this still relevant or will you built on the 13 period date table?

Company Financial Period, DAX or M Code? - #9 by Melissa

[DarrenG]

Hi All,

Thanks for your help.

Melissa’s New code has done the trick!

[Company Financial Period, DAX or M Code?]
(Company Financial Period, DAX or M Code? - #9 by Melissa)

Thank You