Cumulative counts by Months breaking

[siva54]

Hi,

Need to calculate Cumulative Count by months.

The below one is need.

i tried from end but getting like this. Here the dax is calculating for next month also. I need Month wise cumulative.

Thanks in Advance

[amitchandak · Accepted solution]

@siva54 , Try to create a MTD measure using time intelligence and date table

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA