So I am having an issue where by I need to use an iterative formula to give me some totals but not by row as shown in various examples, but by column on a matrix and I cannot figure it out
From image and measure code below you can see that I have row totals working via a SUMX (measure fixed) but my column totals are not (see concrete or excavators). This is because the measure I am using checks for the date in the header to see whether it is in the past, current month or future and works out what values to show accordingly.
The measure fixed formula is what is shown in the matrix
The total column has no date reference so simply uses all three parts of my measure formula to return all values and not just the ones showing in the matrix. Any suggestions?