DAY
Which day of its month a date falls on, 1 to 31.
Group: Date and time. Compatible with DAX.
Syntax
DAY ( <date> )| Parameter | Type | Description |
|---|---|---|
date | Date | A date, a date with a time, or text that reads as one. |
Returns
Whole number. Which day of its month the date falls on, from 1 up to 31.
Remarks
- A blank date gives BLANK.
- Text is read as a date first; a number is taken as a date number, days from 30 December 1899.
DAY ( EOMONTH ( date, 0 ) )is the number of days in the date's month.
Examples
The day of each bond's maturity
EVALUATE
SELECTCOLUMNS (
Holdings,
"Bond", Holdings[Bond],
"Maturity", Holdings[Maturity],
"Day", DAY ( Holdings[Maturity] )
)
ORDER BY [Maturity]| Bond | Maturity | Day |
|---|---|---|
| Government 2028 | 2028-03-02 | 2 |
| Covered 2029 | 2029-06-20 | 20 |
| Corporate 2030 | 2030-11-25 | 25 |
| Municipal 2031 | 2031-09-01 | 1 |
| Government 2033 | 2033-03-15 | 15 |
Days in February
EVALUATE
ROW (
"2024", DAY ( EOMONTH ( DATE ( 2024, 2, 10 ), 0 ) ),
"2025", DAY ( EOMONTH ( DATE ( 2025, 2, 10 ), 0 ) )
)| 2024 | 2025 |
|---|---|
| 29 | 28 |