DATE DAX Function in Power BI
The DATE DAX function returns the specified date in datetime format.
DAX Syntax DATE(year, month, day)
The function has the following parameters:
• year: It specifies a number representing the year. The four-digit year (e.g., 2025).
• month: It specifies a number for month. (1 for January, 12 for December).
• day: It specifies a number for day of the month (1 to 31).
Example: The following formula returns the date Jan 15, 2024.
DAX
Date value = DATE(2024, 1, 15)
The output of the above code is shown below:
