Syntax null Description Allows the OData service to omit null values. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / ODataOmitValues.Nulls
Syntax Cube.ApplyParameter(cube as table, parameter as any, optional arguments as nullable list) as table Description Returns a cube after applying parameter with arguments to cube. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Cube.ApplyParameter
Syntax PostgreSQL.Database(server as text, database as text, optional options as nullable record) as table Description Returns a table of SQL tables and views available in a PostgreSQL database on server server in the database instance named database. The port may be optionally specified with the… Read More »PostgreSQL.Database
Syntax Cube.Properties(cube as table) as table Description Returns a table containing the set of available properties for dimensions that are expanded in the cube. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / Cube.Properties
Syntax AzureStorage.Tables(account as text) as table Description Returns a navigational table containing a row for each table found at the account URL, account, from an Azure storage vault. Each row contains a link to the azure table. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions /… Read More »AzureStorage.Tables
Syntax null Description ‘All’ distribution option for SAP HANA. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Accessing Data Functions / SapHanaDistribution.All
Syntax Cube.AddAndExpandDimensionColumn(**cube** as table, **dimensionSelector** as any, **attributeNames** as list, optional **newColumnNames** as any) as table Description 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. The dimension… Read More »Cube.AddAndExpandDimensionColumn
Evaluates the year-to-date value of the expression in the current context.
Evaluates the value of the expression for the dates in the quarter to date, in the current context.
Evaluates the value of the expression for the month to date, in the current context.