## How does the DATESBETWEENfunction (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 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.

## 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))