Date count and value sum over day, month and year

[Anonymous]

Hi,

This is the formula which I am using to get the values in the first column.

It's counting all the dates but what I want is for the value added to be split over day,month and year in each column.

H date (Column) count =
CALCULATE(COUNTA('Lead'[CreatedDate]
))

Please can you help.

[Anonymous]

Hi, 

Thank you for your reponse.

I just needed the days counted but summed up per day. So if I have an entry of 1 count for july the 5 times would I still use the count method? How would I sum up the each day with different counts.

[v-xiaosun-msft · Accepted solution]

Hi @Anonymous ,

I wonder whether I understand your problem correctly. Do you need to split your date columns to "year", "month","day", and then count them?

Then you can use COUNT function.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.  

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.