How to Isolate Weekdays in Power BI Query

George Apostolov
Updated 05 Oct 2026
- ▣ Power BI

How to Isolate Weekdays in Power BI Query: step-by-step guide

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

Quick answer: 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.

About this Power BI tutorial

Filter weekends from your dataset and keep only weekdays using the Power Query Editor in Power BI with this step-by-step guide. This guide shows how to isolate Weekdays in Power BI Query in 12 steps, starting with "Start by clicking the 'Transform data' button in your 'Home' tab" and finishing with "That's it! You've just isolated weekdays in your dataset using Power Query". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.