DAY DAX Function (Date and Time)
Returns a number from 1 to 31 representing the day of the month.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Date |
A date in datetime format. |
Return values
An integer number indicating the day of the month.
Remarks
If the argument is a string, it is translated into a datetime value using the same rules applied by the DATEVALUE function.
If the argument is a number, DAY converts it to a datetime value. The integer part of the number is the number of days after December 30, 1899. For example, DAY ( 45000 ) returns 15, because 45000 is March 15, 2023.
The result is always the day of the Gregorian calendar. The display format of the date does not change the result. For example, with a Hijri display format, DAY returns the day of the equivalent Gregorian date.
» 3 related functions
Examples
-- Extract date parts from a date
EVALUATE
ADDCOLUMNS (
SAMPLE ( 10, VALUES ( 'Date'[Date] ), 'Date'[Date], ASC ),
"Year", YEAR ( 'Date'[Date] ),
"Quarter", QUARTER ( 'Date'[Date] ),
"Month", MONTH ( 'Date'[Date] ),
"Day", DAY ( 'Date'[Date] )
)
ORDER BY 'Date'[Date]
| Date | Year | Quarter | Month | Day |
|---|---|---|---|---|
| 2005-01-01 | 2,005 | 1 | 1 | 1 |
| 2005-10-12 | 2,005 | 4 | 10 | 12 |
| 2006-07-23 | 2,006 | 3 | 7 | 23 |
| 2007-05-03 | 2,007 | 2 | 5 | 3 |
| 2008-02-11 | 2,008 | 1 | 2 | 11 |
| 2008-11-20 | 2,008 | 4 | 11 | 20 |
| 2009-08-31 | 2,009 | 3 | 8 | 31 |
| 2010-06-11 | 2,010 | 2 | 6 | 11 |
| 2011-03-22 | 2,011 | 1 | 3 | 22 |
| 2011-12-31 | 2,011 | 4 | 12 | 31 |
Related articles
Learn more about DAY in the following articles:
-
Using weekly calendars in Power BI
This article describes why week-based calendars (like 4-4-5) are important for specific industries and how to use them effectively in Power BI. » Read more
Related functions
Other related functions are:
Last update: Nov 11, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/day-function-dax