DAX Function Guide

DATE
Empty image or helper icon

Sam McKay

CEO & Founder

How does the DATE work?
The DATE function (DAX) returns the specified date in datetime format.
DATE Formula Syntax

DATE(
     <year>, <month>, <day>
)

How do you use the DATE?

The DATE function is most useful in situations where the year, month, and day are supplied by formulas. For example, the underlying data might contain dates in a format that is not recognized as a date, such as YYYYMMDD. You can use the DATE function in conjunction with other functions to convert the dates to a number that can be recognized as a date.

Related Blog Posts

Loading

Considerations when using the DATE?

The DATE function takes the integers that are input as arguments, and generates the corresponding date.

In contrast to Microsoft Excel, which stores dates as a serial number, DAX date functions always return a datetime data type. However, you can use formatting to display dates as serial numbers if you want.

This DAX function may return different results when used in a model that is deployed and then queried in DirectQuery mode.

Related Video Tutorials

Loading

Formula examples using the DATE

=DATE(2009,7,8)

=DATE(08,1,2)

=DATE(08,1,2)

Related Courses

Loading