Handling Weekday vs. Weekend Dates in Power BI Using DAX

No comments

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.

All the best.

Sam

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online

 

***Learn more about Enterprise DNA Membership***membership banner 3

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s