Estimated Burndown of Tasks

zane.baranovska · January 19, 2021, 5:14pm

You may have a similar report for the project, version, or some other business unit with begin and end dates.

This report would require few adjustments:

Import project start and end dates. For example, those could be project properties from Profields or additionally imported project properties.
Replace measure “Time within Sprint” with a similar measure “Time within Project” that would mark Time periods (months, weeks, days) between project begin and end dates. For example, if you have Project properties Start date and End date the expression might look like this:
```
CASE WHEN
  DateBetween([Time].CurrentHierarchyMember.StartDate,
  DateAddDays([Project].CurrentHierarchyMember.get('Start date'), -1),
  [Project].CurrentHierarchyMember.get('End date') )
THEN 1
END
```

Replace measure “Sprint Estimated Guideline” with a similar measure “Project Estimated Guideline”. Replace sprint dates with project dates. And for the total scope of estimated hours, you may select the Remaining estimated hours at the first date of the project. The formula might look like this:

CASE WHEN -- period when project is active
  DateBetween([Time].CurrentHierarchyMember.StartDate,
    [Project].CurrentMember.get('Start date'),
    [Project].CurrentMember.get('End date')
  )
  OR 
  DateInPeriod(
    [Project].CurrentMember.get('Start date'),
    [Time].CurrentHierarchyMember
  )
THEN
  --remaining estimated huors when project starts
  ([Measures].[Remaining estimated hours history],
  [Time].CurrentHierarchy.Levels('Day').DateMember(
    [Measures].[Profields Start Date (pf)]) ) *
  --multiplied by remaining days in project
  (
    DateDiffWorkdays(
      [Project].CurrentMember.get('Start date'),
      [Project].CurrentMember.get('End date')
    ) -
    DateDiffWorkdays(
      [Project].CurrentMember.get('Start date'),
      [Time].CurrentHierarchyMember.StartDate
    )
  ) /
  --divided by total count of days in period
  DateDiffWorkdays(
    [Project].CurrentMember.get('Start date'),
    [Project].CurrentMember.get('End date')
  )
END

The main idea of how to construct the burn-down or burn-up reports (represent relative periods and create guideline) is also described for two other user cases in the documentation:

Best,
Zane / support@eazyBI.com