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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Daily Average for each Fiscal Quarter

Hello Community, 

 

I am looking to calculate the daily average incidents for each quarter, and I am not quite sure how to go about it. I have calculcated the number of incidents per quarter using DISTINCTCOUNT('Table'[incidents]) : 

 

Q1 only.PNG

 

I am doing a YoY quarterly comparison, and my fiscal year starts in October, so Q1 =Oct, Nov, Dec. 

 

What I don't know how to do is now divide the number of incidents by the total number of days in the quarter. 

 

I have a date table, and one column does contain the number of days in the month, my fiscal quarter is also in the date table. 

 

Thank you for the help, 

 

Denisse 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hello, I solved it using the following: 

Sum Incidents = DISTINCTCOUNT('FireRMS Continuous Incident'[incidentnumber])
 
CY Daily Average Incidents =
AVERAGEX(
VALUES('Date Table'[Date]),
[Sum Incidents]
)
 
Hope this helps, 
 
Denisse

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hello, I solved it using the following: 

Sum Incidents = DISTINCTCOUNT('FireRMS Continuous Incident'[incidentnumber])
 
CY Daily Average Incidents =
AVERAGEX(
VALUES('Date Table'[Date]),
[Sum Incidents]
)
 
Hope this helps, 
 
Denisse
krishna0
Helper II
Helper II

Hello,

 

Are you able to share your report file/dataset or at least a part of it? It would be convenient to test out some possibilties.

 

Best regards,

Anonymous
Not applicable

I do not know how to share my report file here, i don't know how to attach it. Would you know? 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.