# How to Isolate Weekdays in Power BI Query

> To isolate weekdays in Power Query, open the editor from the Home tab, extract the day of week as a number from your date column using the Add Column tab, filter out Saturday (6) and Sunday (0), and save your changes via Close & Apply in the File menu.

Canonical: https://livedemo.ai/tutorials/how-to-isolate-weekdays-in-power-bi-query/
Apps: Power BI
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a47a5ab56e05a00ff229f/preview?step=1

## Steps

1. Start by clicking the 'Transform data' button in your 'Home' tab.
2. This opens the Power Query Editor. Navigate to the 'Add Column' tab in the ribbon.
3. Click on the date column you want to extract weekdays from.
4. In the 'Add Column' tab, find and click on the 'Date' option.
5. From the dropdown menu that appears, select 'Day'.
6. Then choose 'Day of week' - this adds a new column showing the day number (0-6).
7. Now, click the filter dropdown arrow on your new 'Day of Week' column.
8. Time to banish the weekend! Uncheck the values for Saturday (6) and Sunday (0).
9. Click 'OK' to apply your filter and show only weekdays.
10. Click on the 'File' menu in the top-left corner.
11. Select 'Close & Apply' to save your changes and return to Power BI.
12. That's it! You've just isolated weekdays in your dataset using Power Query.