PREVIOUSQUARTER DAX Function

The PREVIOUSQUARTER time-intelligence function returns a table that contains a single column of all dates from the previous quarter, based on the first date in the dates column, in the current context.

For example, if the first date in the dates argument refers to June 10, 2009, this function returns all dates for the quarter January to March, 2009.

Quarters in a Year

PREVIOUSQUARTER dax function

DAX Syntax PREVIOUSQUARTER(dates)

The parameter date is a column containing dates.

Example: The following sample formula creates a measure that calculates the Sum of previous quarter income.

DAX

Sum of previous quarter income = CALCULATE(SUM(Sheet8[Annual Income]), PREVIOUSQUARTER('Sheet8'[Year]))
PREVIOUSQUARTER dax function

Here, the value 3741000 comes from the sum of Annual Income column value of dates from 1st July 2005 to 30 Sep 2005. The above values are blank because there is no previous quarter before this date. Therefore, indirectly we can say there is no date in the Year column before 1st of July 2005.

Previous Next