Month

returns the month component of a DateTime value, ranging from 1 to 12.

The Month() function in Power FX extracts the month from a given DateTime value. The expected result is ranging from 1 to 12.

Syntax

Month(ThisItem.DateTimeColumn)

ThisItem.DateTimeColumn: The column that 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: Month(ThisItem.Deadline)

Result: 9