Month and year Wise Cumulative Calculation Needed

[Anonymous]

Hi, 

I can calculate Cumulative based on Day Wise, by using the below measures

Cumulative =

CALCULATE

( SUM ( table[value] ),

FILTER

(

ALLSELECTED ( table[date] ),

(table[date] <= MAX ( table[date])

)

And the result will show like day wise,as below

But i dont want day wise , need month and year wise,Example  as below.

@amitchandak @Jihwan_Kim @tamerj1 

[negi007]

@Anonymous  you can create a ytd measure like below

YTD_2 = TOTALYTD(SUM('table'[value]), [table].[Date])

you can also use new quick measure by right clicking on any of the column like below. There you can create a YTD measure as well.

[Anonymous]

Hi,

No, its not wokring for only Month and year. i need like below,