Syntax Number.Atan2(y as nullable number, x as nullable number) as nullable number Description Returns the arctangent of the division of the two numbers, y and x. The division will be constructed as y/x. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Number Functions / Number.Atan2
Syntax Currency.From(value as any, optional culture as nullable text, optional roundingMode as nullable number) as nullable number Description Returns a currency value from the given value. If the given value is null, Currency.From returns null. If the given value is number within the range of… Read More »Currency.From
Syntax Number.RoundAwayFromZero(number as nullable number, optional digits as nullable number) as nullable number Description Returns the result of rounding number based on the sign of the number. This function will round positive numbers up and negative numbers down. If digits is specified, number is rounded… Read More »Number.RoundAwayFromZero
Syntax Logical.From(value as any) as nullable logical Description Returns a logical value from the given value. If the given value is null, Logical.From returns null. If the given value is logical, value is returned. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Logical Functions /… Read More »Logical.From
Syntax Logical.ToText(logicalValue as nullable logical) as nullable text Description Creates a text value from the logical value logicalValue, either true or false. If logicalValue is not a logical value, an exception is thrown. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Logical Functions / Logical.ToText
Syntax Logical.FromText(text as nullable text) as nullable logical Description Creates a logical value from the text value text, either “true” or “false”. If text contains a different string, an exception is thrown. The text value text is case insensitive. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M… Read More »Logical.FromText
Syntax List.Numbers(start as number, count as number, optional increment as nullable number) as list Description Returns a list of numbers given an initial value, count, and optional increment value. The default increment value is 1. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / List Functions… Read More »List.Numbers
Syntax List.RemoveLastN(list as list, optional countOrCondition as any) as list Description Returns a list that removes the last countOrCondition elements from the end of list list. If list has less than countOrCondition elements, an empty list is returned. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions… Read More »List.RemoveLastN
Syntax List.TransformMany(list as list, collectionTransform as function, resultTransform as function) as list Description Returns a list whose elements are projected from the input list. The collectionTransform function is applied to each element, and the resultTransform function is invoked to construct the resulting list. The collectionSelector… Read More »List.TransformMany
Syntax List.DateTimes(start as datetime, count as number, step as duration) as list Description Returns a list of datetime values of size count, starting at start. The given increment, step, is a duration value that is added to every value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M… Read More »List.DateTimes