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. The problem of the Week is an ongoing series where we solve real-world scenarios through DAX and Power Query. 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, power bi datediff working days post image

I’m going to show you how to calculate workdays  / working days 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

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