cancel
Showing results for
Did you mean:
Member

## rolling 12 month that starts over at the year

I have a rolling sum calculated column, but my problem is that I really just want it to roll up that year only.  Then when a new year starts, it goes back to zero.  Here is the formula for the column. How can I get this to check the year?

Rolling= calculate (sum([count]),

filter(

all('Turnover No team'),

'Turnover No team'[Year.Month]<= earlier('Turnover No team'[Year.Month])

))

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User

## Re: rolling 12 month that starts over at the year

Try adding a check on the year to the condition in the filter expression:

```Rolling =
CALCULATE (
SUM ( [count] ),
FILTER (
ALL ( 'Turnover No team' ),
'Turnover No team'[Year.Month] <= EARLIER ( 'Turnover No team'[Year.Month] )
&& YEAR ( 'Turnover No team'[Year.Month] )
= YEAR ( EARLIER ( 'Turnover No team'[Year.Month] ) )
)
)```
2 REPLIES 2
Highlighted
Super User

## Re: rolling 12 month that starts over at the year

Try adding a check on the year to the condition in the filter expression:

```Rolling =
CALCULATE (
SUM ( [count] ),
FILTER (
ALL ( 'Turnover No team' ),
'Turnover No team'[Year.Month] <= EARLIER ( 'Turnover No team'[Year.Month] )
&& YEAR ( 'Turnover No team'[Year.Month] )
= YEAR ( EARLIER ( 'Turnover No team'[Year.Month] ) )
)
)```
Member

## Re: rolling 12 month that starts over at the year

I actually tried that, but I think had the year () wrong somewhere. Thanks!

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 112 members 1,656 guests
Recent signins: