Skip to main content

Date & Time Functions

Date & Time DAX functions help you create calculations based on dates and time. Mostly functions in DAX are similar to the Excel date and time functions.

However, DAX functions use a datetime data type, and can take values from a column as an argument.

Microsoft Power BI DAX provides various types of Date & Time Functions such as:

DATE & TIME DAX Functions

CALENDAR

CALENDARAUTO

DATE

DATEDIFF

DATEVALUE

DAY

YEAR

MONTH

QUARTER

HOUR

MINUTE

SECOND

EDATE

EOMONTH

TIME

TIMEVALUE

NOW

TODAY

WEEKDAY

WEEKNUM

YEARFRAC