desktop - cumulative total

[pcray]

Hi

Is someone able to point me in the right direction

ive created a cumulative total for the last 12 months (rolling - see image)

I would like to create a second column to show the previous 12 months (shown with yellow marker)

this would then allow me to create calculations to understand % change between the two totals

thanks

[Phil_Seamark · Accepted solution]

Hi @pcray

This might be close

Year L12Mths Prev = 
CALCULATE(
    [Year L12Mths]
    ,SAMEPERIODLASTYEAR('Dates'[Date])
    )

[v-jiascu-msft · Accepted solution]

Hi @pcray,

How about this one?

New =
CALCULATE (
    [total],
    DATESINPERIOD (
        dates[date],
        LASTDATE ( DATEADD ( 'dates'[Date], -12, MONTH ) ),
        -12,
        MONTH
    )
)

Best Regards,

Dale

[Phil_Seamark · Accepted solution]

Hi @pcray

This might be close

Year L12Mths Prev = 
CALCULATE(
    [Year L12Mths]
    ,SAMEPERIODLASTYEAR('Dates'[Date])
    )

[pcray]

Hi

Is someone able to point me in the right direction

ive created a cumulative total for the last 12 months (rolling - see image)

I would like to create a second column to show the previous 12 months (shown with yellow marker)

this would then allow me to create calculations to understand % change between the two totals

thanks

peter