Returns the dates between two given dates.
A column reference containing dates.
A table containing a single column of date values.
The dates argument must be a reference to a date/time column.
The result table includes only dates that exist in the dates column.
If StartDate is a blank date value, then StartDate will be the earliest value in the dates column.
If EndDate is a blank date value, then EndDate will be the latest value in the dates column.
The dates used as the StartDate and EndDate 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 StartDate is larger than EndDate, the result is an empty table.
Contributors: Alberto Ferrari, Marco Russo, Jes Hansen
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/datesbetween-function-dax