Add count for month

[nicolasvc]

I have two columns, one with the date and the other in year-month format, and I want to add a third one that is a counter for each day that goes by, and when it is a new month that it restarts. I was able to do it in total, but not that it restarts per month, and I'm getting very complicated.

Date	Month
2022/06/01	2022/06
2022/06/02	2022/06
...	...
2022/06/01	2022/07

Date	Month	count
2022/06/01	2022/06	1
2022/06/05	2022/06	2
...	...	...
2022/06/01	2022/07	1

[Anonymous · Accepted solution]

HI @nicolasvc,

You can try to use the following measure formula to get the count based on the current date and current month group:

formula =
CALCULATE (
    COUNT ( Table[Date] ),
    FILTER ( ALLSELECTED ( Table ), [Date] <= MAX ( Table[Date] ) ),
    VALUES ( Table[Month] )
)

Regards,

Xiaoxin Sheng

[speedramps]

Hi we wnat to help but please provide a lot more examples not just 3 dates and take care to avoid typing mistakes

Explain the missing dates. Why does it jump from 22/06/01 to 2022/06/05 ? 

And why is 2202/06/01 in month 2022/06 and  2022/07.   It does not make sense and looks like typing mistakes.