The MovingMax (Moving Maximum) function operates over a moving window of values. For each Window, the MovingMax returns the maximum 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 MovingMax function takes the following arguments:
MovingMax (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 integer 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 MovingMax function with a Window of 3 (MovingMax(Sales,3).