How to create a dynamic measure that sums month's results based on date

[o59393]

Hi all

How can I have a dynamic measure that sums month's results based on date you select.

Let me do an example:

If you choose March 2020, the measure should sum January result + February result + March result

If you chosse June 2020,  

the measure should sum January result + February result + March result + April result + May result + June result

I have done it like this but it's not an elegant way because it's fixed:

  How can I get this in one single measure as you select the month on the date slicer

Pbix https://1drv.ms/u/s!ApgeWwGTKtFdhzn31uwUJsSK0da4?e=NsXu7e

Thanks!

[CNENFRNL]

Hello, @o59393, you may want to try

KPI YTD = SUMX ( DATESYTD ( Sheet1[Reporting period] ), [Crash Rate] )