Saurabh Jain
-
Posts
1,724 -
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
-
Infers the granular number type (Int64.Type, Double.Type, and so on) of a number encoded in text.
-
Buffers a table into memory, isolating it from external changes during evaluation.
-
Sorts the rows in a table using a comparisonCriteria or a default ordering if one is not specified.
-
Appends a column with the ranking of one or more other columns.
-
Returns the smallest N rows in the given table. After the rows are sorted, the countOrCondition parameter must be specified to further filter the result.
-
Returns the smallest row or rows from a table using a comparisonCriteria.
-
Returns the largest N rows from a table. After the rows are sorted, the countOrCondition parameter must be specified to further filter the result.
-
Returns the largest row or rows from a table using a comparisonCriteria.
-
Replaces specific rows from a table with the new rows.
-
Removes all occurrences of rows from a table.
-
Determines the position or positions of any of the specified rows within the table.
-
Determines the position or positions of a row within a table.
-
Determines whether a table contains only distinct rows.
-
Removes duplicate rows from a table, ensuring that all remaining rows are distinct.
-
Determines whether any of the specified records appear as rows in the table.
-
Determines whether all of the specified records appear as rows in the table.
-
Determines whether the a record appears as a row in the table.
-
Returns a table with columns converted to rows and rows converted to columns from the input table.
-
Transforms the rows from a table using a transform function.
-
Transforms the column types from a table using a type.
-
Transforms the values of one or more columns.
-
Returns a new set of columns from a single column applying a splitter function to each value.
-
Replaces oldValue with newValue in specific columns of a table, using the provided replacer function, such as text.Replace or Value.Replace.
-
Replaces the keys of the specified table.
-
Replaces the error values in the specified columns with the corresponding specified value.
