Cube.AddMeasureColumn

Cube.AddMeasureColumn is a function in the Power Query M language that adds a column containing the results of a measure applied in the row context of each row in the cube. The function returns the cube with the new measure column, which is affected by dimension granularity and slicing changes.

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

Syntax

Cube.AddMeasureColumn(
   cube as table,
   column as text,
   measureSelector as any,
) as table

Description

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. Measure application is affected by changes to dimension granularity and slicing. Measure values will be adjusted after certain cube operations are performed.

Related functions

Other functions related to Cube.AddMeasureColumn are:

• Cube.AddAndExpandDimensionColumn
• 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

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/cube-addmeasurecolumn
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.