Forum Discussion
Solved
Calculation groups in Power BI
I have two calculation groups Calculation group 1 Name Jan-24 Feb-24 Mar-24 Apr-24 May-24 TotalC TotalB TotalA Rate ewrr 1 2 3 4 4 14 867 80 36.36% Calculation group...
Hi Preboat
I am assuming each column in your sample tables is a calculation item. If so, that is a lot of work and if there are more months then you will need to add them manually.
I would use a combination of a calculation group for the calculation and a disconnected table for the column headers.
Please see the attached pbix.
Preboat Not entirely sure, but perhaps you need something like this?
The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community
Hi Greg_Deckler thanks for responding with a possible solution. I am going to try this.
Thanks