Aggregate Sprint Names

[gerda.grantina]

Hi @Shel_Price ,

For my previous calculation to work for your naming pattern, this would be the formula for “Sprint 13” (the same should be repeated for the next sprints):

Aggregate(
  Filter(
    [Sprint].[Sprint].Members,
    [Sprint].CurrentMember.Name MATCHES ".*2021.13$"
  )
)

Or you can try this regular expression to improve the aggregated result: “^PMWeb.*2021.13$”

But if you want for them to be created automatically then you may find this community answer more suitable:

Combining different teams sprints into one

With version 6.1 we added a new to create custom hierarchies in some dimensions, including Sprints. You would like to import custom properties for sprints to represent a potential grouping mechanism. For example, you can import a property cycle for Sprints with additional data import. Then you can use this custom property Cycle to build a new custom hierarchy in Sprint dimension and group sprints by cycles dynamically. Import additional property to Sprint based on Sprint naming pattern XX Spr…

For that solution to work for your use case, you need to adjust the JavaScript in REST API import option to match your Sprint name pattern.

Kind regards,
Gerda