DATESBETWEEN Function (DAX)

How does the DATESBETWEEN function (DAX) work?

The DATESBETWEEN function (DAX) returns a table that contains a column of dates that begins with the start_date and continues until the end_date.

DATESBETWEEN Formula Syntax

DATESBETWEEN(
     <dates>,<start_date>,<end_date>
)

How do you use the DATESBETWEEN function?

The DATESBETWEEN function is provided for working with custom date ranges.

Related Blog Posts

Related Support Forum Posts

DATESBETWEEN, DATESINPERIOD, DATEDIFF functions
Grand Total (which is correct) is not equal as the addition of the several items
Average of a measure between two dates

Considerations when using the DATESBETWEEN function

If start_date is a blank date value, then start_date will be the earliest value in the dates column.

If end_date is a blank date value, then end_date will be the latest value in the dates column.

The dates used as the start_date and end_date are inclusive: that is, if the sales occurred on September 1 and you use September 1 as the start date, sales on September 1 are counted.

If you are working with common date intervals such as months, quarters, and years, we recommend that you use the appropriate function, such as DATESINPERIOD.

Related Video Tutorials

Formula examples using the DATESBETWEEN function

=CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), DATESBETWEEN(DateTime[DateKey], DATE(2007,6,1), DATE(2007,8,31) ))

= CALCULATE(SUM(FactSales[Net_Sales]), DATESBETWEEN(tbl_Calendar[Date_Id], DATE(2016,10,1), DATE(2016,12,31) ))

= CALCULATE ( SUM (Sales[Sales Amount]), DATESBETWEEN (Sales[Date], DATE (2015,1,1), DATE (2015,3,31))

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.