How to order dimension sprint by Name

Questions & Answers
1

Hi,

Please could you help me to order the dimension in the first column by name ASC?

image
image477×756 26.3 KB

The formula of the sprint dimension I used:

Aggregate(
Generate(
– get all boards
[Sprint].[Board].Members,
– access all children - sprints from the board and get the last 1 closed
Tail(
Filter(
[Sprint].CurrentMember.Children,
[Sprint].CurrentMember.GetBoolean(“Closed”)),
1)
)
)

Thanks, Jedid-Jah

2

@eazyBI-Staff can you help me?

3

Hi,

Please, apply the Order function on top of Generate:

Aggregate(
Order(
Generate(
-- get all boards
[Sprint].[Board].Members,
-- access all children - sprints from the board and get the last one closed
Tail(
Filter(
[Sprint].CurrentMember.Children,
[Sprint].CurrentMember.GetBoolean("Closed")),
1)
),
[Sprint].CurrentMember.GetCaption,
BASC
)
)

Kindly,
Janis, eazyBI support

4

Thank you very much @janis.plume !