Cube.AddAndExpandDimensionColumn

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

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 attributes are added to the tabular view with columns named newColumnNames, or attributeNames if not specified.

Related functions

Other functions related to Cube.AddAndExpandDimensionColumn are:

• Cube.AddMeasureColumn
• Cube.ApplyParameter
• Cube.AttributeMemberId
• Cube.AttributeMemberProperty
• Cube.CollapseAndRemoveColumns
• Cube.Dimensions
• Cube.DisplayFolders
• Cube.MeasureProperties
• Cube.MeasureProperty
• Cube.Measures
• Cube.Parameters
• Cube.Properties
• Cube.PropertyKey
• Cube.ReplaceDimensions
• Cube.Transform

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/cube-addandexpanddimensioncolumn