Forum Discussion
Add count for month
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 |
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
2 Replies
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.
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
