Rolling 12 months issue

Hi!

I´m struggling to create a new measure that shows the sum of the last 12 months. I would be very grateful if someone could help.

This is the problem:

- I have the measure "Execution" from the dataset (excel). It is the cummulative sum in the fiscal year (July to June). 

- In Power BI I created a new measure called "Execution" that calculates the execution for each month:

Execution = CALCULATE([Execution]-[Previous Month Execution])

Where:

Previous Month Execution = CALCULATE([Execution];PREVIOUSMONTH('Date'[Date]);'Date'[Month]<>"June")

 

All of this is correct. But now I need to show the sum of the last 12 month of Execution. For doing that in Power BI I created a new measure called "L12M" using this formula:

L12M = CALCULATE (

[Execution];

DATESBETWEEN (

'Date'[Date];

NEXTDAY ( SAMEPERIODLASTYEAR ( LASTDATE ('Date'[Date]) ) );

LASTDATE ( 'Date'[Date])

)

)

 

But instead of the sum of Execution, it is showing the sum of cummulated Execution.

Does anyone know what I am doing wrong?

 

Thank you so much for your help!!!