topic Re: Rolling year in DAX Commands and Tips

Rolling year

Anonymous — Sat, 27 Jun 2020 06:58:06 GMT

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

Re: Rolling year

stevedep — Sat, 27 Jun 2020 06:14:32 GMT

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

Re: Rolling year

AntrikshSharma — Sat, 27 Jun 2020 07:45:40 GMT

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

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