I am creating a report for Planned vs Accepted Features in a PI. I am using Created for Planned and Closed for Accepted.
We use a Custom Field for PI with Values that increment "NRO_22_1, NRO_22_2…)
Whilst Features should only have one PI, there are times when they have two. Created show correctly in two PI’s. I want to have closed only show in the row with the highest value of PI. Is this possible?
A solution to this use case could be the following custom measure:
[Program Increment].CurrentHierarchyMember is
Order ([Program Increment].[Program Increment].GetMembersByKeys([Measures].[Issue Program Increment]),
This formula assumes that Program increment names can be ordered alphabetically in descending order, giving the latest Program increment in the first place.
Janis, eazyBI support
Thank you so much for this. It works perfectly.