Tag: Workday and Weekday Numbers

Time Period Analysis – Intro To Problem Of The Week #10

WORKING W TIME TABLES DAX PROBLEM

In today’s blog, we’ll discuss Problem of the Week #10. Problem of the Week is an ongoing series where we solve real-world scenarios through DAX and Power Query. For this week, we’ll deal with a time period analysis. You may watch the full video of this tutorial at the bottom of this blog. The problem

Continue reading

Calculate Workdays Between Two Dates In Power BI

Calculating Workdays Between Two Dates in Power BI

I’m going to show you how to calculate workdays between two dates either with the holidays counted or without the holidays. This is a topic that’s been asked over and over again on the Enterprise DNA Forum. I also believe that this will be a great way to close this Time Intelligence series, knowing that

Continue reading

Adding Workday And Weekend Numbers Into Your Date Table: Time Intelligence Technique In Power BI

This is a very unique example of Time Intelligence in Power BI, especially when working with workdays and weekends. You may watch the full video of this tutorial at the bottom of this blog. This tutorial came ftom a request from the Enterprise DNA Support Forum, where a member needed to get the day for

Continue reading