Cube.AddAndExpandDimensionColumn is a function in the Power Query M language that merges a dimension table into a cube’s filter context and expands specified dimension attributes. The function returns a modified cube with new dimensional granularity and additional columns.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


   cube as table,
   dimensionSelector as any,
   attributeNames as list,
   optional newColumnNames as any,
) as table


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.

Other functions related to Cube.AddAndExpandDimensionColumn are:

BI Gorilla Blog

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.