DateAddWorkdays
EAZYBI Returns date plus specified number of workdays.
Syntax
DateAddWorkdays(date, days) DateAddWorkdays(date, days, nonworkdays)
Arguments
| date | Date expression. |
|---|---|
| days | Integer expression for number of working days to add. By default Saturdays and Sundays are considered as non-working days. |
nonworkdays | Specify string with non-working day numbers (use 1 for Monday, 2 fort Tuesday, 3 for Wednesday, 4 for Thursday, 5 for Friday, 6 for Saturday, 7 for Sunday). If not specified then If Time dimension options are specified then these Time dimension non-working days will be used (in this case please do not specify this argument). |
Examples
DateAddWorkdays([Issue].CurrentMember.get('Created at'), 5)
DateAddWorkdays([Issue].CurrentMember.get('Created at'), 5, '67')
The example below calculates predicted date to complete unresolved issues based on recent progress in the project
DateAddWorkDays("Today",
-- remaining scope
([Measures].[Issues due],
[Time].CurrentHierarchy.Defaultmember)
/
-- average resolved issues per week in last 52 weeks
AVG(
{[Time.Weekly].[Week].CurrentDateMember.Lag(52):
[Time.Weekly].[Week].CurrentDateMember.PrevMember},
CoalesceEmpty(
([Measures].[Issues resolved],
[Time].DefaultMember),
0)
)
* 5 -- workdays in week
)
See report example Predicted completion date in our Demo account. The calculated measure Rolling predicted date uses the formula above to calculate a date in how many days from today unresolved issues will be resolved if the progress will be similar to the last 52 weeks and no new issues will come in. Remaining scope / average pace per week gives a count of predicted weeks. They are multiplied by 5 workdays per week to get total predicted workdays that could be added from Today.