Window

MOVINGAVERAGE is a DAX function that calculates a moving average along a specified axis in a visual calculation data grid. Syntax Argument Properties Description Expression The … Read More

MATCHBY is a DAX function that specifies the columns used to match data and identify the current row within a Window function. Syntax Argument Properties Description … Read More

LAST is a DAX function that retrieves a value from the last row of an axis in a visual calculation data grid. Syntax Argument Properties Description … Read More

ISATLEVEL is a DAX function that reports whether a column is present at the current hierarchy level. Syntax Argument Properties Description Column A column in the … Read More

INDEX is a DAX function that retrieves a row at a specific position within a partition sorted by a specified order or axis. Syntax Argument Properties … Read More

FIRST is a DAX function that retrieves a value from the first row of an axis in a visual calculation data grid. Syntax Argument Properties Description … Read More

EXPANDALL is a DAX function that retrieves a context with all added detail levels along an axis compared to the current context. Syntax Argument Properties Description … Read More

EXPAND is a DAX function that retrieves a context with added detail levels compared to the current context. Syntax Argument Properties Description Expression Optional The expression … Read More

COLLAPSE is a DAX function that retrieves a context with removed detail levels compared to the current context, allowing navigation up hierarchies and calculation at … Read More

COLLAPSEALL is a DAX function that retrieves a context with removed detail levels along an axis, enabling navigation to the highest level on the axis … Read More