Forum Discussion

kastriot's avatar
kastriot
Frequent Visitor
7 years ago
Solved

Average per quarter

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 understandin...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    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.

themistoklis's avatar
themistoklis
Community Champion
7 years ago

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's avatar
kastriot
Frequent Visitor
7 years ago

That worked great. Thank you