Remaining hour guideline per Project?

calculatedmembers

#1

I am looking to create a burn down guideline for a project, not a sprint. All the examples I see are for sprints, using sprint specific timeline items. My project has a set start and end date. I only want to include work that had an original estimate. Any help would be greatly appreciated.

Based on this example:
(Filter([Time].CurrentMember.Level.Members,
[Measures].[Time within Sprint] > 0).Item(0),
[Measures].[Remaining estimated hours history])

  • DateDiffDays([Time].CurrentMember.StartDate,
    [Sprint].CurrentMember.get(‘End date’))
    / DateDiffDays([Sprint].CurrentMember.get(‘Start date’),
    [Sprint].CurrentMember.get(‘End date’))

I got this far, but it simply doesn’t return data:
(
Filter([Time].CurrentMember.Level.Members,
[Measures].[Original estimated hours with sub-tasks] > 0).Item(0),
[Measures].[Remaining estimated hours history]
)
*DateDiffDays(DateParse(‘2019 01 25’),DateParse(‘2019 03 08’))
/DateDiffDays(Now(),DateParse(‘2019 03 08’))


#2

Hi,

Please try the following calculated measure instead:

CASE WHEN
DateBetween([Time].CurrentHierarchyMember.StartDate,
DateParse(‘2019-01-25’), DateParse(‘2019-03-08’))
THEN
(
Filter([Time].CurrentMember.Level.Members,
[Measures].[Original estimated hours with sub-tasks]> 0).Item(0),
[Measures].[Remaining estimated hours history]
)
*
DateDiffDays([Time].CurrentHierarchyMember.StartDate,DateParse(‘2019-03-08’))
/
DateDiffDays(DateParse(‘2019-01-25’), DateParse(‘2019-03-08’))
END    

It should calculate the guideline between two project dates which you enter manually in the code.

Martins / eazyBI support