Forum Discussion
Calculate difference between two dates excluding weekends?
I'm trying to calculate the difference between two dates, and realized that Power BI doesn't have a "Net working days" function like Excel does. How do you calculate a date difference between two different dates in Power BI?
| Date 1 | Date 2 | Business Days Elapsed? |
| 01/01/2020 | 01/02/2020 | ?? |
| 02/02/2020 | 02/09/2020 | ?? |
| 02/02/2020 | 02/26/2020 | ?? |
Anonymous , Refer to This file. On the second page there are working days calculations
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
or refer
https://www.youtube.com/watch?v=9M1V_m-oEzc
1 Reply
Anonymous , Refer to This file. On the second page there are working days calculations
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
or refer
https://www.youtube.com/watch?v=9M1V_m-oEzc