Forum Discussion

chestern's avatar
chestern
Regular Visitor
4 years ago
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 ...
Need Help
  • chestern's avatar
    chestern
    4 years ago

    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]
chestern's avatar
chestern
Regular Visitor
4 years ago

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]
  • Gabriel_Walkman's avatar
    Gabriel_Walkman
    Icon for Continued Contributor rankContinued Contributor
    4 years ago

    This will not work every fourth year, which will have one more day in them. 

     

    Why do separate measures?

     

    I recommend having an if depending how many months have been selected, ie. diatinctcount( 'Calendar'[Month]) > 2).

     

    I hope you are using a separate calendar table?