Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

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
1 ACCEPTED SOLUTION
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
2 REPLIES 2
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User

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.

Helpful resources

Announcements

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors