Handling Weekday vs. Weekend Dates in Power BI Using DAX

It’s important for many businesses to make sure that you are analyzing over the correct sales periods or correct time periods in which you actually have results.

If you implement formulas incorrectly in Power BI, especially with iterating functions like AVERAGEX or SUMX, and you iterate over days where you don’t actually have results or days you don’t have any sales, then you are actually going to get incorrect results.

Sometimes unknowingly you’ll place these results into your reports and not immediately pick up if they are correct or incorrect.

Within this tutorial I’m going to showcase how you can isolate weekdays and weekends and only retrieve information for those particular time periods.

This is going to be particularly valuable if you’re an organization which only sells during the week or if you’re wanting to isolate your weekend sales, as that might be where the bulk of your sales are occurring.

The key concept to understand here is iterating functions. You must get your head around these and understand how they work very, very well. If you do, you will see that you can change the shape of any virtual table within these functions to be able to isolate, in this case, any time period.

From here, we can branch out even more and find really great insights across various different factors in our data model or even compare one to the other. You can even compare weekday results to weekend results.

Plenty of great analytical insights that you can discover by implementing these ideas and techniques well.