topic Daily Average for each Fiscal Quarter in DAX Commands and Tips

Daily Average for each Fiscal Quarter

Anonymous — Tue, 01 Jun 2021 16:05:35 GMT

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

Re: Daily Average for each Fiscal Quarter

krishna0 — Tue, 01 Jun 2021 17:03:23 GMT

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,

Re: Daily Average for each Fiscal Quarter

Anonymous — Thu, 03 Jun 2021 16:37:21 GMT

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

Re: Daily Average for each Fiscal Quarter

Anonymous — Mon, 07 Jun 2021 15:39:11 GMT

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