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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dcomad3a
Regular Visitor

Count of Items per Month

This seems like it should be simple but I can't seem to figure it out nor find the solution within the community. I have a Date table I created and I want to count the number of items created within each month, for example 10 items in Jan, 15 in Feb, etc. I placed the month column on my X-axis and the Created On column on my Y-axis but what I get in return is the total number of items showing up in each month. 

 

 

 

Count per month.pngPer Month Count.png

1 ACCEPTED SOLUTION
marcelsmaglhaes
Super User
Super User

Hey @dcomad3a ,

You can try use COUNTROWS function in a DAX measure. See the image bellow

marcelsmaglhaes_0-1704927616098.png

marcelsmaglhaes_1-1704927668820.png

 

 


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!
Imagem de fundo



View solution in original post

2 REPLIES 2
marcelsmaglhaes
Super User
Super User

Hey @dcomad3a ,

You can try use COUNTROWS function in a DAX measure. See the image bellow

marcelsmaglhaes_0-1704927616098.png

marcelsmaglhaes_1-1704927668820.png

 

 


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!
Imagem de fundo



Thank you, Marcel. I was using the formula incorrectly but it is working now using Countrows.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.