Power Query
published
Search
⌃K

Cube.AddAndExpandDimensionColumn

Cube.AddAndExpandDimensionColumn

Merges the specified dimension table into the cube?s filter context and changes the dimensional granularity of the filter context by expanding the specified set of dimension attributes.
function (cube as table, optional dimensionSelector as nullable any, attributeNames as list, optional newColumnNames as nullable 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 attributes are added to the tabular view with columns named newColumnNames, or attributeNames if not specified.

Category

Cube