- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
DAX Date & Time - CALENDAR function
Description
Returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates.
DAX CALENDAR function is new in Excel 2016.
Syntax
CALENDAR (<start_date>, <end_date>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
start_date Any DAX expression that returns a datetime value. |
2 |
end_date Any DAX expression that returns a datetime value. |
Return Value
Returns a table with a single column named “Date” containing a contiguous set of dates.
Remarks
An error is returned if start_date is greater than end_date.
Example
= COUNTROWS (CALENDAR (DATE (2016,8,1), DATE (2016,10,31))) returns 92.
dax_functions_date_time.htm
Advertisements