Evaluates the value of the expression for the dates in the quarter to date, in the current context.




expressionAn expression that returns a scalar value.
datesA column that contains dates.
filter(optional) An expression that specifies a filter to apply to the current context.

Return Value

A scalar value that represents the expression evaluated for all dates in the current quarter to date, given the dates in dates.


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.


The following sample formula creates a measure that calculates the ‘quarter running total’ or ‘quarter running sum’ for Internet sales.


See also

ALL function (DAX)
CALCULATE function (DAX)
TOTALYTD function (DAX)
TOTALMTD function (DAX)

***** Related Blog Posts *****
60 Page DAX Formula Reference Guide Download Now Available
Show Only Top Or Bottom Results Using Ranking Formula Techniques – Power BI & DAX

***** Related Video Tutorials *****
Ultimate Beginners Guide to DAX

What Is DAX? & Why Do You Need To Learn It – (1.2) Ultimate Beginner Guide to DAX
Formula Syntax, Comments & Variables – (1.6) Ultimate Beginners Guide to DAX
Examples Of Advanced DAX – (1.18) Ultimate Beginners Guide to DAX

***** Related Course Modules *****
Ultimate Beginners Guide to DAX
Mastering DAX Calculations
Solving Analytical Scenarios w/ Power BI and DAX
DAX Formula Deep Dives
Advanced DAX Combinations

***** Related Support Forum Posts*****
Mastering DAX Calculations: What Is DAX?
Understanding DAX Formula
Developing Complex Dax functions
Data Types And Operators