Cumulative values starting by currently month but sum the past values

[danielmorais]

Hello everyone, 

I need some help here...

I need to create a measure that calculates cumulative values starting by currently month but sum the past values.

Example:

Thanks

[danielmorais]

@Greg_Deckler 

It works perfectly!!!

Thank you so much!

[Greg_Deckler · Accepted solution]

@danielmorais Maybe:

Measure =
  VAR __Today = TODAY()
  VAR __Start = DATE(YEAR(__Today),MONTH(__Today),1)
  VAR __Month = MAX('Table'[Month])
  VAR __Table = FILTER(ALL('Table'),[Month] <= __Month)
RETURN
  IF(__Month < __Start,0,SUMX(__Table,[Value]))