Cube.CollapseAndRemoveColumns

Syntax

Cube.CollapseAndRemoveColumns(**cube** as table, **columnNames** as list) as table

Description

Changes the dimensional granularity of the filter context for the cube by collapsing the attributes mapped to the specified columns columnNames. The columns are also removed from the tabular view of 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.CollapseAndRemoveColumns