DAX Date & Time - CALENDAR function


Advertisements

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

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements