# Tableau WINDOW_AVG Function

×

## Definition

WINDOW_AVG is a Tableau Table Calculation function. It returns the average of the expression within the window. The function accepts offsets from the current row as parameter values to determine the start and end positions. ×

## How to use WINDOW_AVG function

The WINDOW_AVG function returns the average of the expression defined by the offsets provided. If we provide no values for the start and end, then it calculates average for all rows. WINDOW_AVG ( expression , [ start , end ] )
×

## Use WINDOW_AVG function in a formula

The WINDOW_AVG function below calculates the average of the sum of Price starting from the first row to the last row of the window. WINDOW_AVG ( SUM ( [Price] ) , FIRST() , LAST() )
×

## Use WINDOW_AVG function with current row

The WINDOW_AVG function here calculates the average of the sum of Price starting from the third row to the current row of the window. The 0 offset indicates the current row. WINDOW_AVG ( SUM ( [Price] ) , FIRST() + 2 , 0 )
×

## Example of WINDOW_AVG in Tableau

WINDOW_AVG function calculates the average of the expression for all the rows from the start and end offsets provided as parameter. In the below example, the offsets provided are FIRST() and LAST(), so all the rows are considered.

×