Forum Discussion
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...
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
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