Semi-Additive Measures Min/Max

It would be highly beneficial to include a MIN/MAX function for semi-additive measures, as there is currently no alternative that is both performant, easy to maintain, and capable of reacting dynamically to changes in data.

I’ve encountered this need in several use cases:

• Risk Analysis:

  We aggregate risk assessments over multiple years. Within a higher-level aggregation, we need to display only the maximum risk value, rather than summing or averaging the underlying data, to accurately reflect the highest assessed risk.

• Project Planning:

  Larger project phases consist of multiple sub-phases, each with its own start and end dates. For the aggregated phase, we need to derive:

  
  

  • the earliest start date (MIN), and

  • the latest end date (MAX),

    to correctly represent the full duration of the parent phase.