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.

FunctionDescription
Time.EndOfHourReturns a DateTime value from the end of the hour.
Time.FromReturns a time value from a value.
Time.FromTextReturns a Time value from a set of date formats.
Time.HourReturns an hour value from a DateTime value.
Time.MinuteReturns a minute value from a DateTime value.
Time.SecondReturns a second value from a DateTime value
Time.StartOfHourReturns the first value of the hour from a time value.
Time.ToRecordReturns a record containing parts of a Date value.
Time.ToTextReturns a text value from a Time value.
Show: