Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to calculate the number of days between 2 different dates excluding the weekends.
Currently I'm doing manualy on Excel with the function Networkdays but the ideal is to be implemented on Power BI as new colum. Any idea how it can be done?
Solved! Go to Solution.
To calculate the net workdays, I suggest you add a calculated column in your date table.
IfWorkDay = SWITCH( WEEKDAY('Table'[Date],2), 6,0, 7,0, 1)
Then you can calculate the net work days based on above column.
[Net WorkDays]= CALCULATE(SUM('Table'[IfWorkDay]),DATESBETWEEN('Table',<start_date>,<end_date>))
Regards,
To calculate the net workdays, I suggest you add a calculated column in your date table.
IfWorkDay = SWITCH( WEEKDAY('Table'[Date],2), 6,0, 7,0, 1)
Then you can calculate the net work days based on above column.
[Net WorkDays]= CALCULATE(SUM('Table'[IfWorkDay]),DATESBETWEEN('Table',<start_date>,<end_date>))
Regards,
FOR
IfWorkDay = SWITCH( WEEKDAY('Table'[Date],2), 6,0, 7,0, 1)
Is the Variable DATE the from date or to date in my table to calculate the difference? Sorry new to PowerBI
Ddi you looked at this post on the forum:
http://community.powerbi.com/t5/Desktop/Networkdays-DAX-function/m-p/38597
Thanks,
P
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
106 | |
88 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |