How to Isolate Weekdays in Power BI Query

Quick summary

This tutorial shows how to isolate weekdays in Power BI using the Power Query Editor by adding a Day of Week column and filtering out Saturday and Sunday values. It is a fast, no-code approach to cleaning date data so your reports reflect only business days.

Steps

1. Click the Transform data button in the Home tab to open the Power Query Editor.
2. Navigate to the Add Column tab in the Power Query Editor ribbon.
3. Click on the date column you want to extract weekday information from.
4. In the Add Column tab, click the Date option.
5. From the dropdown menu, select Day.
6. Choose Day of Week to add a new column showing the day number (0–6).
7. Click the filter dropdown arrow on the new Day of Week column.
8. Uncheck the values for Saturday (6) and Sunday (0) to exclude weekends.
9. Click OK to apply the filter and display only weekday rows.
10. Click the File menu in the top-left corner of the Power Query Editor.
11. Select Close & Apply to save your changes and return to Power BI.
12. Your dataset now contains only weekday records, ready for business-day reporting.