DAX_Date and Time Functions

Name	Syntax	Return	Description	Status
CALENDAR	`CALENDAR(<start_date>, <end_date>)`	Table	Returns a table with a single column named "Date" that contains a contiguous set of dates	In progress
CALENDARAUTO	`CALENDARAUTO([<fiscal_year_end_month>])`	Table	Returns a table with a single column named "Date" that contains a contiguous set of dates.	In progress
DATE	`DATE(<year>, <month>, <day>)`	DateTime	Returns the specified date in datetime format	In progress
DATEVALUE	`DATEVALUE(<date_text>)`	DateTime	Converts a date in the form of text to a date in datetime format.	In progress
TIME	`TIME(<hour>, <minute>, <second>)`	DateTime	Converts hours, minutes, and seconds given as numbers to a time in datetime format.	In progress
TIMEVALUE	`TIMEVALUE(<time_text>)`	DateTime	Converts a time in text format to a time in datetime format.	In progress
TODAY	`TODAY()`	DateTime	Returns the current date	In progress
NOW	`NOW()`	DateTime	Returns the current date and time in datetime format	In progress
UTCTODAY	`UTCTODAY()`	DateTime	Returns the current UTC date.	In progress
UTCNOW	`UTCNOW()`	DateTime	Returns the current date and time in Coordinated Universal Time (UTC)	In progress
DAY	`DAY(<date>)`	Integer	Returns the day of the month, a number from 1 to 31.	In progress
MONTH	`MONTH(<date>)`	Integer	Returns the month as a number from 1 (January) to 12 (December)	In progress
YEAR	`YEAR(<date>)`	Integer	Returns the year of a date as a four digit integer	In progress
HOUR	$HOUR(<datetime>)$	Integer	Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.)	In progress
MINUTE	`MINUTE(<datetime>)`	Integer	Returns the minute as a number from 0 to 59, given a date and time value.	In progress
SECOND	`SECOND(<datetime>)`	Integer	Returns the seconds of a time value, as a number from 0 to 59.	In progress
QUARTER	`QUARTER(<date>)`	Integer	Returns the quarter as a number from 1 to 4	In progress
WEEKDAY	`WEEKDAY(<date>, [<return_type>])`	Integer	Returns a number from 1 to 7 identifying the day of the week of a date	In progress
WEEKNUM	`WEEKNUM(<date>, [<return_type>])`	Integer	Returns the week number for the given date and year according to the return_type value.	In progress
DATEDIFF	`DATEDIFF(<start_date>, <end_date>, <interval>)`	Integer	Returns the count of interval boundaries crossed between two dates	In progress
EDATE	`EDATE(<start_date>, <months>)`	DateTime	Returns the date that is the indicated number of months before or after the start date	In progress
EOMONTH	`EOMONTH(<start_date>, <months>)`	DateTime	Returns the date in datetime format of the last day of the month, before or after a specified number of months	In progress
YEARFRAC	`YEARFRAC(<start_date>, <end_date>, [<basis>])`	Decimal	Calculates the fraction of the year represented by the number of whole days between two dates	In progress
NETWORKDAYS	`NETWORKDAYS(<start_date>, <end_date>, [<holidays>])`	Integer	Returns the number of whole workdays between two dates.	In progress