Returns the minium value of a numeric expression 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.
|MDX expression that returns set.|
|MDX expression that returns a number.|
|Min value of Numeric_expression over set|
The following example calculates the minimum 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 min amount of resolved issues in the last 52 weeks.
- Description of aggregate functions
- Function CASE WHEN
- Function Max and Avg
- Function DatediffDays
- Function IsEmpty and CoaleceEmpty
- Function Descendants
- Function Filter