Forum Discussion

DennisSchlein's avatar
DennisSchlein
Icon for Helper III rankHelper III
2 years ago

Add X network days to start date

Hi  Im working on a forecast model, where I have a start date and a amount of working days to completion. Could be StartDate 18-04-2024 Exptected Task Working Days :  5 Would expect ...
hekp
DennisSchlein's avatar
DennisSchlein
Icon for Helper III rankHelper III
2 years ago

Hi 

I give full access to the foler, to this onedrive folder with the sample file.

Onedrive Sample File 


Thank you for the effort! 🙂 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DennisSchlein ,

 

Please try this new syntax:

End Date =
VAR _date = DATE(YEAR('sample'[CMR_Close]),MONTH('sample'[CMR_Close]),DAY('sample'[CMR_Close])+'sample'[E2E])
VAR _dateadd2 = DATE(YEAR('sample'[CMR_Close]),MONTH('sample'[CMR_Close]),DAY('sample'[CMR_Close])+'sample'[E2E])+2
RETURN
IF(WEEKDAY(_date,2)IN{6,7},_dateadd2,_date)

 

The visual effect of the page is as follows:

 

pbix file is attached.

 

If you have any further questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!