Total Issues points in done status with done date greater than X date

Hi - total newbie here for EazyBI

I have a report I’m trying to create where I have a measure to calculate the story points at the end of the sprint, but I want to be able to additionally only loom at those stories that are created beyond 1/1/2023

([Measures].[Sprint Story Points at closing],
[Status].[Done])

Not sure where to go after this. Thank you!

Hello @sam1

Welcome to eazyBI community!

When reading your requirements, it was not entirely clear whether your goal is to obtain story points for those issues that are with “done date” greater than Jan 1, 2023 or issues with “creation date” greater than Jan 1, 2023.
I have written two solutions for you below. In the below calculation, I am using the Descendants() function where eazyBI iterates through every issue and filters (with Datecompare() function) those issues, where the creation or resolution dates match your criteria (greater than Jan 1, 2023).
Then using Measure “Sprint Story Points completed”, the calculation sums up the story points at sprint closing in the status category “Done”

Solution for returning results for issues created after Jan 1, 2023

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateCompare([Measures].[Issue created date],"Jan 1, 2023")>0
        ),
 [Measures].[Sprint Story Points completed]
   )

Solution for returning results for issues resolved after Jan 1, 2023

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateCompare([Measures].[Issue resolution date],"Jan 1, 2023")>0
        ),
  [Measures].[Sprint Story Points completed]
   )

Let me know if I missed something and if you have some further questions!
Kind regards,