Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi,
I have a dataset that is similar to the below.
| Start Date | Duration (Days) |
| 01/01/2023 | 1 |
| 01/02/2023 | 5 |
| 01/03/2023 | 23 |
I need to create a calculated column to show the end date. This end date must be the start date + duration whilst excluding weekends.
For example if the start date fell on a friday and had a duration of two days, the end date would fall on the coming monday.
Many thanks 🙂
Solved! Go to Solution.
| User | Count |
|---|---|
| 51 | |
| 38 | |
| 33 | |
| 22 | |
| 19 |
| User | Count |
|---|---|
| 136 | |
| 101 | |
| 58 | |
| 36 | |
| 35 |