DAY DAX Function (Date and Time)

Syntax  |  Return values  |  Remarks  |  Examples  |  Articles  |  Related  

Returns a number from 1 to 31 representing the day of the month.

Syntax

DAY ( <Date> )

Parameter	Attributes	Description
Date		A date in datetime format.

Return values

Scalar A single integer value.

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.

» 1 related article
» 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:

• MONTH
• YEAR
• YEARFRAC

Last update: Nov 2, 2026   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation: https://docs.microsoft.com/en-us/dax/day-function-dax