The MovingMin function operates over a moving window of values. For each Window, the Moving Minimum returns the minimum value found in the Window. This function is similar to the Simple Moving Average. No “Weighted” or “Exponential” can be calculated for this function.
The MovingMin function takes the following arguments:
MovingMin (column, window, break_col)
column (required)—Specify the column that contains the numeric fact on which the Moving Function column value is calculated. If you are applying the function from the Pivot section, you can only use a column that has already been added to the Facts pane of the data layout.
window (optional)—Specify a moving “window” of values from the Column on which the Moving Function gets calculated The window value must be a positive integer of value equal to or less than the total number of rows in the Column (within any Break Column value).
If the window value is an interger of greater value than the number of values in the Column, then the window value defaults to the number of rows in the Column (within any Break Column value). If no window value is specified, then the window value defaults to 3.
break column (optional)—Specify the name of the column on which to perform the Moving Function calculation. The break column refers to the rows of similar valued data cell within the Pivot or Results section.
The following results would occur if you used the Moving Minimum function with a Window value of 3.
Similar to Simple Moving Averages above, note that the values in the "3-Month Moving Minimum" column are positioned according to the trailing averages.