Rolling 12 Month SUM

[Anonymous]

Thanks to all who reply,

I have a table showing material #, Revenue, Qty. I created a card to display the Rolling 12 mth Revenue total.

Net Sales rolling 12 mth =

CALCULATE(

SUM ( salesMaster[netRevenue] ),

DATESBETWEEN (

'Date Table'[Date],

NEXTDAY(SAMEPERIODLASTYEAR ( LASTDATE ('Date Table'[Date] ) ) ), LASTDATE('Date Table'[Date] )))

Date Table for years 2017- 2022.

The problem is that I am only seeing the revenue total for this year (2022). I need to include the previous 8 months from 2021.

I want the Card to show the previous 12 months up to the current month. ( May 2021 - April 2022 ).   

Thank you!

BLD

[CNENFRNL · Accepted solution]

Net Sales rolling 12 mth =
CALCULATE(
    SUM( salesMaster[netRevenue] ),
    DATESINPERIOD( 'Date Table'[Date], MAX( 'Date Table'[Date] ), -12, MONTH )
)

[Anonymous]

Yes this works. Thanks!