DAX summarizing values with sum of previous months

[Monika_85]

Hey!

I'm looking for a DAX that could show values by month but each month has to be a sum of previous month and filtered month:

Month	Values	Sum
1	1	1
2	1	1+1
3	1	1+1+1

So, instead of 3 as a total, it should show 6 as a total.

[Sahir_Maharaj]

Hello @Monika_85,

Can you please try this: 

Running Total = 
VAR CurrentMonth = MAX('Table'[Month])
VAR FilteredTable = FILTER('Table', 'Table'[Month] <= CurrentMonth)
RETURN SUMX(FilteredTable, 'Table'[Values])

Let me know if you might require further assistance.

[Monika_85]

Hey @Sahir_Maharaj 

Thanks for helping me. Unfortunately, this DAX doesn't help me as I wish. Using it, I receive sum by month and I'd like to have sthg like that:

January = sum of January values

February = sum of January + February values

March = sum of January + February + March values

etc.