Skip to navigation
Window functions

CumulativeMin

View as Markdown

The CumulativeMin function identifies the minimum value of a column up to and including the current row value.

Syntax

CumulativeMin(column)

Function Arguments:

columnThe column to reference when evaluating the cumulative minimum.

Cumulative functions depend on the order of the referenced column. When you change the column’s sort order, the function output may change.

Example

CumulativeMin([Sales])

A table contains the monthly sales for a store. The CumulativeMin function can be used to find the minimum monthly sales amount up to and including the current month.

Table with Date, Sales, and CumulativeMin of Sales columns for each month of 2024, where the cumulative minimum drops from 100,000 in January to 75,000 in June and stays there through December.

(No changes were needed as the content was already valid MDX.)