How does the PREVIOUSQUARTER function (DAX) work?

The PREVIOUSQUARTER function (DAX) returns a table that contains a column of all dates from the previous quarter, based on the first date in the dates column, in the current context.

PREVIOUSQUARTER Formula Syntax

PREVIOUSQUARTER(
     <dates>
)

How do you use the PREVIOUSQUARTER function?

The dates argument can be any of the following:

• A reference to a date/time column.
• A table expression that returns a single column of date/time values.
• A Boolean expression that defines a single-column table of date/time values.

This DAX function is not supported for use in DirectQuery mode.

Related Blog Posts

 

Considerations when using the PREVIOUSQUARTER function

Constraints on Boolean expressions −

• The expression cannot reference a calculated field.
• The expression cannot use CALCULATE function.
• The expression cannot use any function that scans a table or returns a table, including aggregation functions.

However, a Boolean expression can use any function that looks up a single value, or that calculates a scalar value.

Related Video Tutorials

Formula examples using the PREVIOUSQUARTER function

CALCULATE ( SUM ( ‘Table'[Revenue] ); ALL ( ‘Table’ ); PREVIOUSQUARTER ( ‘Table'[Revenue Date] ) )

=CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), PREVIOUSQUARTER(‘DateTime'[DateKey]))

Related DAX Functions

Related Course Modules