Forum Discussion
Custom Subtotals in Matrix
Hi Elias-AR
Those extra rows must exist physically in your model as you can't assign a value to a row that doesn't exist - so you either modify your dimension table or create a new one. In the example below, Difference is the delta between the latest and the month before that and is an extra row in a custom dimension table.
A measure is then created that references the Period column in this dimension table returning the value for each period and whethey they should be shown and the Difference depending on the period selected in the slicer. Please see the attached sample pbix.
Hi Elias-AR
Those extra rows must exist physically in your model as you can't assign a value to a row that doesn't exist - so you either modify your dimension table or create a new one. In the example below, Difference is the delta between the latest and the month before that and is an extra row in a custom dimension table.
A measure is then created that references the Period column in this dimension table returning the value for each period and whethey they should be shown and the Difference depending on the period selected in the slicer. Please see the attached sample pbix.