I am trying to figure out how to build this calculated member to show me all sprints that have a start date after -2023-01-01. The business requirement is to show all the sprints in the sprint filter that started this year, so using the time dimension filter does not work as it does not cascade to the following filter to only show sprints in 2023
Hi @jeffb,
Date comparisons require particular functions in eazyBI and can’t be compared directly with mathematical comparison operators. In your case, I recommend using the Aggregate()
function to group a set of Sprint dimension members. Then use the Filter()
function to retrieve the Sprints that are started after the desired period. Finally, use the DateCompare()
function to compare each Sprint start date with the threshold. The complete formula could look similar to the one below:
Aggregate(
Filter(
[Sprint].[Sprint].Members,
DateCompare(
[Sprint].CurrentMember.Get('Start date'),
'Jan 1 2023'
) > 0
)
)
Please refer to the eazyBI function reference for more details about the mentioned functions - MDX function reference.
Best,
Roberts // support@eazybi.com
thank you. one more question, how can i adjust this to be only sprints in a certain board
Hi @jeffb,
You can replace [Sprint].[Sprint].Members
with [Sprint].[BOARD_NAME].Children
in the calculated measure formula. Use the certain board’s name instead of BOARD_NAME
.
Best,
Roberts // support@eazybi.com