Daily Average for each Fiscal Quarter

[Anonymous]

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]) : 

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 

[Anonymous · Accepted solution]

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]

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]

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