Saurabh Jain
-
Posts
1,726 -
Joined
-
Last visited
-
Days Won
61
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Online Conference
The Excel dictionary
Power Query M function dictionary
Everything posted by Saurabh Jain
-
Returns true if a value is Number.NaN.
-
Returns true if a value is an even number.
-
Returns a text value from a logical value.
-
Returns a logical value of true or false from a text value.
-
Returns a logical value from a value.
-
Converts a list of text into a single text. The specified lineSeparator is appended to each line. If not specified then the carriage return and line feed characters are used.
-
Converts a list of text into a binary value using the specified encoding and lineSeparator.The specified lineSeparator is appended to each line. If not specified then the carriage return and line feed characters are used.
-
Converts a text value to a list of text values split at lines breaks.
-
Converts a binary value to a list of text values split at lines breaks.
-
Returns a list of time values of size count, starting at start.
-
Returns a list of count random numbers, with an optional seed parameter.
-
Returns a list of numbers from size count starting at initial, and adds an increment. The increment defaults to 1.
-
Generates a list of values.
-
Returns a list of durations values from size count, starting at start and adds an increment to every value.
-
Returns a list of of datetimezone values from size count, starting at start and adds an increment to every value.
-
Returns a list of datetime values from size count, starting at start and adds an increment to every value.
-
Returns a list of date values from size count, starting at start and adds an increment to every value.
-
Returns the product from a list of numbers.
-
Returns the covariance from two lists as a number.
-
Returns the sum from a list.
-
Returns the standard deviation from a list of values. List.StandardDeviation performs a sample based estimate. The result is a number for numbers, and a duration for DateTimes and Durations.
-
Returns all items that appear with the same maximum frequency.
-
Returns an item that appears most commonly in a list.
-
Returns an average value from a list in the datatype of the values in the list.
-
Returns one or more sample percentiles corresponding to the given probabilities.
