Forum Discussion

nicolasvc's avatar
nicolasvc
Helper III
4 years ago
Solved

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
  • Anonymous's avatar
    Anonymous
    4 years ago

    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