Syntax Type.Union(types as list) as type Description Returns the union of the types in types. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.Union
Syntax Type.FunctionReturn(type as type) as type Description Returns a type returned by a function type. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.FunctionReturn
Syntax Type.ReplaceFacets(type as type, facets as record) as type Description Replaces the facets of type with the facets contained in the record facets. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Type Functions / Type.ReplaceFacets
Syntax Time.From(value as any, optional culture as nullable text) as nullable time Description Returns a time value from the given value. An optional culture may also be provided (for example, “en-US”). If the given value is null, Time.From returns null. If the given value is… Read More »Time.From
Syntax Time.Second(dateTime as any) as nullable number` Description Returns the second component of the provided time, datetime, or datetimezone value, dateTime. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Time Functions / Time.Second
Syntax Time.FromText(text as nullable text, optional culture as nullable text) as nullable time Description Creates a time value from a textual representation, text, following ISO 8601 format standard. An optional culture may also be provided (for example, “en-US”). Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions… Read More »Time.FromText
Syntax Time.ToText(time as nullable time, optional format as nullable text, optional culture as nullable text) as nullable text Description Returns a textual representation of time. An optional format may be provided to customize the formatting of the text. An optional culture may also be provided… Read More »Time.ToText
Syntax Time.Minute(dateTime as any) as nullable number Description Returns the minute component of the provided time, datetime, or datetimezone value, dateTime. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Time Functions / Time.Minute
Syntax Time.Hour(dateTime as any) as nullable number Description Returns the hour component of the provided time, datetime, or datetimezone value, dateTime. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Time Functions / Time.Hour
Syntax Time.StartOfHour(dateTime as any) as any Description Returns the first value of the hour given a time, datetime or datetimezone type. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Time Functions / Time.StartOfHour