Week Start and Week End Dates in Power Query M

Adds columns for the Monday (week start) and Sunday (week end) of the week each date falls in.

Date & TimeBeginnerweekdatestartend

Power Query M code

let
    Source = YourTable,
    AddedWeekStart = Table.AddColumn(Source, "WeekStart", each Date.StartOfWeek([DateColumn], Day.Monday), type date),
    AddedWeekEnd = Table.AddColumn(AddedWeekStart, "WeekEnd", each Date.EndOfWeek([DateColumn], Day.Monday), type date)
in
    AddedWeekEnd

Generate a date table in Power Query M

Notes

Change Day.Monday to Day.Sunday if your week starts on Sunday.

Requirements

A table with a date column.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Week Start and Week End Dates.