Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Rolling year

Hi guys I need your help with a calculation for a rolling year. Here is the calculation: F% = A(currentmonth going back a year) + B (Full 12 months) - C(full 12 months) + D(full 12 months) - E(For s...
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago

If you are looking for running total then you could try something like this:

 

 

Running Total 2 = 
VAR MaxDateInFilterContext = MAX ( Dates[Date] )
VAR MaxYearInFilterContext = YEAR ( MaxDateInFilterContext )
RETURN
    CALCULATE (
        [Total Sales],
        FILTER (
            ALL ( Dates ),
            Dates[Date] <= MaxDateInFilterContext
                && Dates[Calendar Year Number] = MaxYearInFilterContext
        )
    )

 

or

 

Running Total =
CALCULATE ( [Total Sales], DATESYTD ( Dates[Date] ) )