Forum Discussion
Anonymous
5 years agoNot applicable
Calculated End Date Based on Weekend
Hi all,
I have a data set similar to the one below
| Start Date | Duration (Days) |
| 01/01/2021 | 6 |
| 02/01/2021 | 7 |
| 01/02/2021 | 4 |
I want to create a calculated column titled 'End Date'. This end date needs to exclude weekends.
For example, if a task was to start on 24/05/2021 (Monday) and had a duration of 6 days. I would need the end date to be 31/05/2021 (Monday).
Any help would be much appreciated.
Thanks,
Elliot
Please see this video. It shows how to do it in either DAX or M.
(11) Power BI - Tales from the Front #03 - Due Date From Working Days - YouTube
Pat
1 Reply
- mahoneypatMicrosoft Employee
Please see this video. It shows how to do it in either DAX or M.
(11) Power BI - Tales from the Front #03 - Due Date From Working Days - YouTube
Pat