Forum Discussion
Calculating Business Days without Calendar or Table Editing
Hi all! Fairly new to Power BI and hoping someone can help me out. I've been looking through some suggestions but I can't find any articles that help. I'm trying to calculate Business Days (AKA...
hcvb07 better to post the sample data and expected output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Ideally it would calculation for each row as below and then average to get a total duration of 2.61.
| Start Date | End Date | Duration | Count |
| 4/13/2020 | 4/13/2020 | 0 | 3 |
| 4/13/2020 | 1/0/1900 | 2 | |
| 4/13/2020 | 4/14/2020 | 1 | 9 |
| 4/13/2020 | 4/15/2020 | 2 | 6 |
| 4/13/2020 | 4/16/2020 | 3 | 7 |
| 4/13/2020 | 4/17/2020 | 4 | 5 |
| 4/15/2020 | 4/17/2020 | 2 | 7 |
| 4/15/2020 | 1/0/1900 | 0 | |
| 4/13/2020 | 4/18/2020 | 4 | 9 |
| 4/15/2020 | 4/18/2020 | 2 | 6 |
| 4/13/2020 | 4/19/2020 | 4 | 8 |
| 4/15/2020 | 4/19/2020 | 2 | 9 |
| 4/13/2020 | 4/20/2020 | 5 | 2 |
| 4/15/2020 | 4/20/2020 | 3 | 8 |
| 4/20/2020 | 1/0/1900 | 6 | |
| 4/20/2020 | 4/20/2020 | 0 | 2 |
| 4/13/2020 | 4/21/2020 | 6 | 10 |
| 4/20/2020 | 4/21/2020 | 1 | 6 |