How does the DATE function (DAX) work?
The DATE function (DAX) returns the specified date in datetime format.
DATE Formula Syntax
<year>, <month>, <day>
How do you use the DATE function?
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
Related Support Forum Posts
Considerations when using the DATE function
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
Formula examples using the DATE function
Related DAX Functions
Related Course Modules
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.