Rolling year

[Anonymous]

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 selected month)

This calculation should be dynamic that you can display values for the 12 months.

Currently when I do it it displays the answer at a total level and not the individual months

[AntrikshSharma]

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] ) )

[stevedep]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490