Get date Cumulative story points resolved > 0?

Questions & Answers
1

I’m trying to get the origin point for a burn-up chart based on the date the Cumulative story points measure first has any value > 0.

I currently use a partially working solution based on the discussion here for getting the first issue done date but I find it has a flaw I need to work around: if an issue was mistakenly moved to done and then back again, that date seems to be forever entrenched as the first issue done date.

How do I get the start date based on the Cumulative story points measure? i.e., the Feb. 05 date in the pic below and not the Jan. 04 date.
image

2

Try this formula for calculated measure:

Filter(
  [Time.Weekly].[Week].Members,
  CumulativeSum([Measures].[Story Points resolved])>0
  AND
  DateCompare(
    [Time.Weekly].CurrentMember.StartDate,
    VisibleRowsSet().item(0).item(0).StartDate
  )>0
).item(0).startdate

Martins / eazyBI

image
image1760×1302 252 KB

1 Like
3

Thanks Martin! That works great.