I have a report that lists the Average time to complete individual tasks by Qtr. Each qtr has x number of tasks completed and the report lists the average time taken to complete the task. I need measures that will also give me the min and max time taken in each qtr.
Hi @arkhan
Welcome to eazyBI community!
I recommend using MIN and MAX functions for your use case.
You could define new calculated measures with following formulas:
MIN time:
Min(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod(
[Measures].[Issue resolution date],
[Time].CurrentHierarchyMember)
),
CASE WHEN
-- check if issue is relevant for the report
[Measures].[Issues resolved] > 0
THEN
[Measures].[Average resolution days]
END
)
MAX time:
Max(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod(
[Measures].[Issue resolution date],
[Time].CurrentHierarchyMember)
),
CASE WHEN
-- check if issue is relevant for the report
[Measures].[Issues resolved] > 0
THEN
[Measures].[Average resolution days]
END
)