Date and Time DAX Functions

Calculates the fraction of the year represented by the number of whole days between two …

Returns the month as a number from 1 (January) to 12 (December).

Returns the year of a date as a four digit integer in the range 1900-9999.

Returns the week number for the given date and year according to the return_type value. …

Returns a number from 1 to 7 identifying the day of the week of a …

Returns the current date.

Converts a time in text format to a time in datetime format.

Converts hours, minutes, and seconds given as numbers to a time in datetime format.

Returns the seconds of a time value, as a number from 0 to 59.

Returns the quarter as a number from 1 (January – March) to 4 (October – …

Returns the current date and time in datetime format.

Returns a table with a single column named “Date” that contains a contiguous set of …

Returns the minute as a number from 0 to 59, given a date and time …

Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).

Returns the date in datetime format of the last day of the month, before or …

Returns the date that is the indicated number of months before or after the start …

Returns the day of the month, a number from 1 to 31.

Converts a date in text format to a date in datetime format.

Returns the count of interval boundaries crossed between two dates.

Returns the specified date in datetime format.

Returns a table with a single column named “Date” that contains a contiguous set of …