Need help on getting running total for month

[Heena_9980400]

Hi Experts,

I need help running total or cumulative sum for only months, You can see the requirement screenshot.

How to get the running total monthly wise, Kindly need some suggestion here.

Appreciate your help on this.

Thanks,

hk

[olgad · Accepted solution]

Hi, there has to be a month number column as well, 1,2,3...,12 which you can use. 
In my example I have a seprate calendar/date table

 running total in Month =

CALCULATE (

   Total Sales,,

    FILTER (

        ALL ( 'Calendar'),

      'Calendar'[Date].[MonthNo] <= MAX ( 'Calendar'[Date].[MonthNo] )

    )

)