OpenBI Docs Buy

Time.Minute

The minute, 0 to 59, of a time, datetime or datetimezone.

Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.

Syntax

Time.Minute(dateTime as any) as nullable number
ParameterTypeDescription
dateTimeanyA time, datetime or datetimezone value; null gives null.

Returns

nullable number. The minute of the hour.

Examples

The minute of an order

Time.Minute(#datetime(2024, 3, 15, 14, 30, 0))
30

Of a time

Time.Minute(#time(8, 15, 0))
15

Time.Hour, Time.Second, DateTime.Time.

Last updated · OpenBI Studio 0.3.79