Aggregating Fix Versions regex to capture from the end

Questions & Answers
,
1

I have read the articles on how to aggregate fix versions that all start with the same characters but I can’t seem to get the regex right to aggregate by the same characters at the end. My current work around is to build out the calculated member with a bunch of OR statements, but that seems very kludgey. (see below)

Aggregate(
Filter(
[Fix Version].[Version].Members,
[Fix Version].CurrentHierarchyMember.Name MATCHES ‘OIM - MVP1.5.0’ OR
[Fix Version].CurrentHierarchyMember.Name MATCHES ‘OO - MVP1.5.0’ OR
[Fix Version].CurrentHierarchyMember.Name MATCHES ‘BYP - MVP1.5.0’ OR
[Fix Version].CurrentHierarchyMember.Name MATCHES ‘TME - MVP 1.5.0’ OR
[Fix Version].CurrentHierarchyMember.Name MATCHES ‘WMX - MVP1.5.0’ OR
[Fix Version].CurrentHierarchyMember.Name MATCHES ‘WMX - MVP1.5.0’ OR
)
)

2

Hi, @nick.ehrlich

Welcome to the eazyBI community.

To aggregate the Fix Versions that end with “MVP1.5.0”, please consider using the regular expression that starts with “any symbol” - .* and end should be marked with a $ sign.

The formula for the member should look something like this:

Aggregate(
 Filter(
    [Fix Version].[Version].Members,
    [Fix Version].CurrentHierarchyMember.name matches ".*MVP1.5.0$"
  )
)

Kindly,
Ilze

3

Thank you for the reply. It’s just what I needed. That, and I need to brush up on my regular expressions. :slightly_smiling_face: