Returns the maximum value of a numeric expression that is evaluated over a set.
Before you create the calculated measure with the average function check if you could use standard functionality to add statistical calculations.
|Set_Expression||MDX expression that returns a set.|
|Numeric_Expression||MDX expression that returns a number.|
The following example calculates the maximum time in days for unresolved issues from the last status change till today.
The formula pulls in a set of unresolved issues only and for this set will look for unresolved relevant to report selections and will calculate days for those issues from status updated date till now.
The following example finds the maximum amount of resolved issues in the last 52 weeks.
- Description of aggregate functions
- Function CASE WHEN
- Function Min and Avg
- Function DatediffDays
- Function IsEmpty and CoaleceEmpty
- Function Descendants
- Function Filter