DATESBETWEEN DAX Function in Power BI
The DATESBETWEEN time-intelligence function returns a table that contains a single column of dates that begins with a specified start date and continues until a specified end date. This function is suited to pass as a filter to the CALCULATE function. Use it to filter an expression by a custom date range.
DAX Syntax DATESBETWEEN(Dates, StartDate, EndDate)
Example: Let’s we have a following table named Sheet1 which has Dates column of Date data type as shown in the image below:
Let’s create a calculated table with the following DAX expression.
DAX
DATESBETWEEN Table = DATESBETWEEN('Sheet1'[MyDates],"01-03-1990","13-08-1991")
The output of the above code is shown below:
