Syntax Time.ToRecord(time as time) as record Description Returns a record containing the parts of the given Time value, time. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Time Functions / Time.ToRecord
Syntax Time.EndOfHour(dateTime as any) as any Description Returns a time, datetime, or datetimezone value representing the end of the hour in dateTime, including fractional seconds. Time zone information is preserved. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Time Functions / Time.EndOfHour
Syntax #time(hour as number, minute as number, second as number) as time Description Creates a time value from whole numbers hour hour, minute minute, and (fractional) second second. Raises an error if these are not true: 0 ≤ hour ≤ 24 0 ≤ minute ≤… Read More »#time
Syntax Text.ReplaceRange(text as nullable text, offset as number, count as number, newText as text) as nullable text Description Returns the result of removing a number of characters, count, from text value text beginning at position offset and then inserting the text value newText at the… Read More »Text.ReplaceRange
Syntax null Description A list of positions of all occurrences of the found values is returned. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Occurrence.All
Syntax null Description The position of the last occurrence of the found value is returned. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Occurrence.Last
Syntax null Description Use to choose the UTF16 little endian binary form. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / TextEncoding.Utf16
Syntax Text.Remove(text as nullable text, removeChars as any) as nullable text Description Returns a copy of the text value text with all the characters from removeChars removed. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.Remove
Syntax Text.At(text as nullable text, index as number) as nullable text Description Returns the character in the text value, text at position index. The first character in the text is at position 0. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.At
Syntax Text.Reverse(text as nullable text) as nullable text Description Reverses the provided text. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.Reverse