How to change the week ending to Sunday?

[Melissa]

Hi @Krays23 ,

You can use the Extended Date table which is an ISO-8601 type calendar.

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…

However if you want to stick with that function, you can set the optional start of week day parameter in the Date.EndOfWeek function to Day.Monday