Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Do you have a dedicated Date table?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous 

 

Yes I do. That is where the month and year dimensions referenced would be coming from.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.