Date Table with Working Day / Weekend Flag in Power Query M

Notes

Replace YourDateTable and [Date] with your existing date table and its date column.

Requirements

• A date table with a Date column.

How to use this snippet

1. 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).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Generate a Date TableBuilds a continuous calendar table between two dates with year, month and quarter columns.
• Fiscal Calendar with Custom Start MonthBuilds a calendar table where the fiscal year and fiscal month are calculated from a custom fiscal year start month instead of January.
• Holiday Table GeneratorFlags dates in a date table that match a manually maintained list of holiday dates.
• Time Table (Hour and Minute Buckets)Generates a standalone table of every minute in a day, useful for time-of-day analysis and slicers.
• Business Days Between Two DatesCalculates the number of weekdays (Monday-Friday) between two dates, excluding weekends.
• Month-Year Sort Column (e.g., 2026-03)Adds a sortable text column combining year and month so month names sort chronologically instead of alphabetically.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Date Table with Working Day / Weekend Flag.