Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hey @dcomad3a ,
You can try use COUNTROWS function in a DAX measure. See the image bellow
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
Hey @dcomad3a ,
You can try use COUNTROWS function in a DAX measure. See the image bellow
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
Thank you, Marcel. I was using the formula incorrectly but it is working now using Countrows.