Solved: Calculated End Date Based on Weekend

Anonymous · ‎05-26-2021

Hi all,

I have a data set similar to the one below

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

mahoneypat · ‎05-26-2021

Please see this video. It shows how to do it in either DAX or M.

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

mahoneypat · ‎05-26-2021

Please see this video. It shows how to do it in either DAX or M.

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Calculated End Date Based on Weekend