Running / Cumulative Total Resetting Each Month

[kc_]

Hello All 

I would like to create a measure that calculates a running total which resets at the beginning of each month.

I am using the following DAX however as you will see it is summing up values from prior periods which is not what I am after:

I shall be grateful if someone can assist.

Many thanks

[bhanu_gautam · Accepted solution]

@kc_ , Try using below DAX

RunningTotal =
CALCULATE(
SUM('YourTable'[YourColumn]),
FILTER(
ALL('YourTable'),
'YourTable'[Date] <= MAX('YourTable'[Date]) &&
MONTH('YourTable'[Date]) = MONTH(MAX('YourTable'[Date])) &&
YEAR('YourTable'[Date]) = YEAR(MAX('YourTable'[Date]))
)
)

[kc_]

Many thanks!