Day

returns the day component of a DateTime value, ranging from 1 to 31.

The Day() function in Power FX extracts the day of the month from a DateTime value, ranging from 1 to 31.

Syntax

Day(ThisItem.DateTimeColumn)

DateTimeColumn: The column contains the DateTime data

Example

In the table of Task track, there is a column Deadline which has a data value of September 18, 2024.

Syntax: Day(ThisItem.Deadline)

Result: 18