Forum Discussion
Solved
Calculate daily average across months
Hello, I am attempting to calculate the average number of incidents reported per day across the months of September and October, which have 30 and 31 days respectively. I have 25 total incidents ...
I just figured it out. I created two measures:
Measure = IF(COUNT(Base[Date Reported].[Date])=365, 61, COUNT(Base[Date Reported].[Date]))Measure 2 = COUNT(Base[Classification]) / [Measure]
| Classification | Date Reported |
| Incident 1 | 9/1/2021 |
| Incident 2 | 9/3/2021 |
| Incident 3 | 9/5/2021 |
| Incident 4 | 9/7/2021 |
| Incident 5 | 9/9/2021 |
| Incident 6 | 9/11/2021 |
| Incident 7 | 9/13/2021 |
| Incident 8 | 9/15/2021 |
| Incident 9 | 9/17/2021 |
| Incident 10 | 9/19/2021 |
| Incident 11 | 9/21/2021 |
| Incident 12 | 9/23/2021 |
| Incident 13 | 9/25/2021 |
| Incident 14 | 9/27/2021 |
| Incident 15 | 9/29/2021 |
| Incident 1 | 10/2/2021 |
| Incident 2 | 10/4/2021 |
| Incident 3 | 10/6/2021 |
| Incident 4 | 10/8/2021 |
| Incident 5 | 10/10/2021 |
| Incident 6 | 10/12/2021 |
| Incident 7 | 10/14/2021 |
| Incident 8 | 10/16/2021 |
| Incident 9 | 10/18/2021 |
| Incident 10 | 10/20/2021 |