Placing Workday And Weekend Day Numbers Into The Date Table In Power BI

No comments

This is a very unique example for when working with workdays and weekend days in Power BI.

It came directly out of a request from the Enterprise DNA Support Forum where a member needed to get the day for each weekday but also the day of each weekend into their date table.

Compare Weekday and Weekend Results versus previous years – Actual and YTD numbers – Power BI

Forum 1

So the requirement was for the first weekday to be one, then two and then three. If for example, the day after that is a weekend, then that needs to start at one again and then two for the weekend days.

This is obviously quite a unique requirement but one that I can see having some broad application, especially if you need to compare like for like days between different months.

This was all to be placed within a calculated column as well, which meant considering the context of each row inside the date table.

Once you work through the logic and you see how it’s applied inside of the date table (which is a must-have table inside of any data model), you’ll be quite surprised at how seamlessly you can run this calculation in Power BI versus completing this in any other tool.

We dive into the RANKX function and how you can use it to calculate this unique insight.

Enjoy working through this one. It’s a great idea for new and interesting analysis.

For many more time intelligence concepts and techniques to use in Power BI, check out this particular course module at Enterprise DNA Online.

Time Intelligence Calculations


***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online
Enterprise DNA Events

membership banner 3

***** Related Links*****
How To Create Unique Financial Year Quarters In Power BI
Build A Comprehensive Date Table Really Fast in Power BI

***** Related Course Modules*****
Advanced Analytics
Business Analytics
Unique Analytical Scenarios

***** Related Support Forum Posts*****
Holidays and weekends
Daily Budget w/o Holidays and Weekends & Cumulative Budget Total Issue
Projecting current profit run rate
For more time intelligence queries to review see here…..

Enterprise DNA Events

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.