Average per quarter

[kastriot]

Hello,

I am trying to get the average of the count of [Staff ID] per quarter and I was hoping someone can help me.

Please check the formulas on the right side to maybe have a better understanding of what I am trying to achieve.

So, I am trying to create a formula that takes into account all [Staff ID] MTD and divide it by the Max number of [Month no.]. Of course, I am open to any other approach that might give me the same results.

Thank you

[themistoklis · Accepted solution]

@kastriot

You can use the following formula:

Measure = CALCULATE (
        COUNT ( 'Table'[Staff ID] ),
        FILTER (
            All('Table'),
            'Table'[Quarter] <= MAX ( 'Table'[Quarter] )
        )
    )
/ MAX('Table'[Month No])

Workspace on this link.

[kastriot]

That worked great. Thank you