Forum Discussion
YTD over multiple years
What I would like to display is a matrix by month. I would then have a filter for year. Both the month and year dimensions would come from my calendar table. So in the matrix for January, I would...
Anonymous
Yes I do. That is where the month and year dimensions referenced would be coming from.
try this measure:
Total Sales = SUM( 'Fact Sale'[Total Sales])
Running Total Sales =
CALCULATE(
[Total Sales],
FILTER(
ALL( DimCalendar),
MAX( DimCalendar[Month]) >=DimCalendar[Month]
)
,VALUES( DimCalendar[Year])
)This assumes you have a Month Number column in your date table, as well as a Year column.