Rolling measure that won't stop at the end of year

[gianmarco]

Dear All,

in my data model i have created some measures which contains DATESYTD.

That means I have a rolling measure that ends at the end of the year and restarts at the beginning of next year.

What I want is a measure that won't stop at the end of year but keeps rolling in the years after.

Should I replace DATESYTD with another function?

[Anonymous · Accepted solution]

Hi  @gianmarco ,

Here are the steps you can follow：

1. Create measure.

Sum_Measure =
SUMX(
    FILTER(ALL('Table'),
    'Table'[Date]<=MAX('Table'[Date])),[Value])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[gianmarco]

Exactly what I needed!

[audreygerred]

Sounds like you need a Rolling Xmonths (i.e. 12 months) measure. 

How to Calculate Rolling 12 Months in Power BI - Zebra BI

How to Calculate Rolling X Months in Power BI - Monocroft