Time functions
The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.
| Function | Description |
|---|---|
| Time.EndOfHour | Returns a DateTime value from the end of the hour. |
| Time.From | Returns a time value from a value. |
| Time.FromText | Returns a Time value from a set of date formats. |
| Time.Hour | Returns an hour value from a DateTime value. |
| Time.Minute | Returns a minute value from a DateTime value. |
| Time.Second | Returns a second value from a DateTime value |
| Time.StartOfHour | Returns the first value of the hour from a time value. |
| Time.ToRecord | Returns a record containing parts of a Date value. |
| Time.ToText | Returns a text value from a Time value. |
Show: