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 the tables in the current Excel Workbook.
-
Returns the cubes in an Essbase instance grouped by Essbase server.
-
Returns a table of SQL tables and views available in a Db2 database.
-
Applies the list cube functions, transforms, on the cube.
-
Replaces the set of dimensions returned by Cube.Dimensions.
-
Returns the key of property property.
-
Returns a table containing the set of available properties for dimensions that are expanded in the cube.
-
Returns a table containing the set of parameters that can be applied to cube.
-
Returns a table containing the set of available measures within the cube.
-
Returns the property of a measure.
-
Returns a table containing the set of available properties for measures that are expanded in the cube.
-
Returns a nested tree of tables representing the display folder hierarchy of the objects (for example, dimensions and measures).
-
Returns a table containing the set of available dimensions within the cube.
-
Changes the dimensional granularity of the filter context for the cube by collapsing the attributes mapped to the specified columns columnNames.
-
Returns the property propertyName of dimension attribute attribute.
-
Returns the unique member identifier from a member property value.
-
Returns a cube after applying parameter with arguments to cube.
-
Adds a column with the name column to the cube that contains the results of the measure measureSelector applied in the row context of each row.
-
Merges the specified dimension table, dimensionSelector, into the cube's, cube, filter context and changes the dimensional granularity by expanding the specified set, attributeNames, of dimension attributes.
-
Returns the contents of a CSV document as a table using the specified encoding.
-
This function is unavailable because it requires .NET 4.5.
-
Returns a navigational table containing a row for each table found at the account URL from an Azure storage vault. Each row contains a link to the azure table.
-
Returns the content of the specified file from an Azure Data Lake Storage filesystem.
-
Returns a navigational table containing the documents found in the specified container and its subfolders from Azure Data Lake Storage.
-
Returns a navigational table containing all containers found in the Azure Storage account. Each row has the container name and a link to the container blobs.
