Getting story points before a certain date

Questions & Answers
1

Hi,

I have a report where I am using Issue dimension with ‘epic’ hierarchy. I am displaying issues with a certain fix version. Then I am using the measure to display story points created. However, I want to ‘lock’ the report to stop counting story points for tickets that were closed after a certain date, say May 29, 2020, even if the ticket has the same fix version.

How do I do that? I thought this may work but it gave me an error:

CASE WHEN
[Issue].[Issue].CurrentDateMember <= ‘2020-05-29’
THEN
[Measures].[Current Story Points Created]
END

2

Hi @siasina!

I imagine you could use the Story points resolved measure together with the Time dimension - this shows story points on the date when they were resolved. Then we can filter the Time dimension members to show only up until certain date by using the PreviousPeriods function

Sum(
  PreviousPeriods([Time].[Day].DateMember("2020-05-29")),
  [Measures].[Story Points resolved]
)

Note that you can make this dynamic by suing only story points resolved until version release date:

Sum(
  PreviousPeriods([Time].[Day].DateMember(
    [Measures].[Version release date]
  )),
  [Measures].[Story Points resolved]
)

Lauma / support@eazybi.com