Return Working Days in Power BI using DAX

No video

Return Working Days in Power BI using DAX

Рет қаралды 6,384

Күн бұрын

In this tutorial, we'll show you how to use Data Analysis Expressions (DAX) to return the number of working days in Power BI. We'll walk you through the steps to create a DAX formula that excludes weekends and holidays from your calculation. By the end of this video, you'll have a better understanding of how to use DAX to manipulate and analyze data in Power BI.
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Mitchell30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks... - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2u...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
🔗Pragmatic Works Boot Camps: pragmaticworks...
🔗Pragmatic Works Hackathons: pragmaticworks...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks...
🔗Pragmatic Works Blog: blog.pragmaticw...
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️KZfaq: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks

Пікірлер: 12

@bradj229 9 ай бұрын

Always great to see Mitchell's DAX videos. Thanks!

@shoaibrehman9988 10 ай бұрын

Hi Mitchell this is super exciting, pls keep posting videos for DAX . Thanks for sharing with us.

@pthapa55 10 ай бұрын

Awesome example. This really helps. Thank you for bringing to us.

@jodyswanson7197 8 күн бұрын

Hi Mitchell, your videos are very helpful. Thank you! How could you write this to exclude a 3-day weekend (Fri, Sat, and Sun) and holidays? We work from Monday thru Thursday.

@arne.munther 10 ай бұрын

I made a table with holidays for like then years or more. Holidays names in rows, years as coloumns. That way you can see, the input and easy change it. Very convenient this year, we just lost one holiday from next year :( I used power query to import it.

@shubhabratadey 9 ай бұрын

Awesome video. Simple and very useful

@metalrouge2648 10 ай бұрын

O.o, that made my calculation easier . Thabks.

@user-vj4gg6rx2i 6 ай бұрын

Love it! Thanks.

@nariroeplal1553 4 ай бұрын

Hi could you show the tutorial on how you created true false dax for holidays?

@SiriusScientist 10 ай бұрын

This is great! How would you modify to recognize “country” so you can vary the recognized holidays or work days by region?

@jyotideokar9457 4 ай бұрын

Hi, I want to calculate 7 th working day of next month of given month. For example if my given month is jan 24, I need 7 th working day of Feb'24. Non working days are Saturday and Sunday. But it would be great if we add list of holidays. I tried a lot but no luck. Please help