Matrix column order with Calculation Groups (Measures grouped under Calculation Items instead of the

Hi rampie

Pivot tables are probably the closest Excel equivalent to Power BI matrices, but one feature they have that matrices lack is the ability to move measures to a different level in the hierarchy. A workaround is to create a disconnected table and reference it in a measure. Then, use the column from that table along with the measure and the calculation group in a matrix.

Please see the attached pbix.