How can I find the value written to a custom field at the end of each sprint?

@bluesky

Property “Issue Estimated EndDate” will return the current value of a date picker but you can import the history for date field timestamps and then return the last value at certain date.

See similar question answered here: How can i show the change history of date custom field?
You can impport the timestamps of date picker field changes and then calculate the “End date history” from these changes.

Once the history is imported and the calculated measure is created, you can try creating the final calculated measure (with Month Day Year format) to retrieve the historical date picker field value at the sprint actual end date.

CASE WHEN
Not IsEMpty([Measures].[Sprint actual end date])
THEN
Sum((
  [Time].[Day].DateMember(
    [Measures].[Sprint actual end date]
  ),
  [Measures].[Estimated Enddate history] --calculated measure from community example
))
END

Martins / eazyBI support