Here’s exactly how you can do it:
- Go to the 'Transform data' from your 'Home' tab.
- Select 'Transform data' to open the Power Query Editor.
- Go to 'Add Column'.
- Select the date column.
- Under the 'Add Column', select 'Date'.
- From the menu, select 'Day'.
- Once you have selected the 'Day', choose 'Day of week'.
- Click on the drop-down arrow to filter the weekdays.
- Uncheck the numbers for Sunday and Saturday.
- Once done, click 'OK'.
- Click the 'File' menu.
- Select 'Close & Apply' to save changes.
- Following these steps can help you easily filter weekdays using Power BI queries.
