Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
56 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |