PREVIOUSQUARTER Function (DAX)
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
Related Support Forum Posts
Chart x-axis displayed upon date range slicer
Custom quarter ending on 3rd Friday of quarter’s last month
Quarter On Quarter Sales Trends In Power BI – DAX Formula
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
