Forum Discussion

andreaaizza's avatar
andreaaizza
New Member
9 years ago
Solved

Average count per month per id

Hi there,    have some measurement like below:  id date measure id1 1.6.2017 1010 id2 10.7.2017 1016 id2 1.6.2017 10 id2 10.7.2017 20 id2 15.7.2017 26 Trying to...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    andreaaizza

     

    Hi, you can obtain the desired result in this way:

     

    Step 1: In Query Editor

     

    Parse the Date and Create the column Month-Year

     

     

    Step 2:

     

    Create a Measure:

     

    AVG_Count_Per_month =
AVERAGEX (
    SUMMARIZE (
        Table1,
        Table1[month-year],
        Table1[id],
        "Count", COUNT ( Table1[id] )
    ),
    [Count]
)

    Ready

     

dilumd's avatar
dilumd
Icon for Impactful Individual rankImpactful Individual
9 years ago

Hi,

 

Please use below function,

m_MonthlyAvg = DIVIDE(SUMX('Count',[m_Count]),COUNTA('Count'[Count]))

 

andreaaizza's avatar
andreaaizza
New Member
9 years ago

Hi dilumd, 

Thanks and sorry for being dummy: how do you create m_Count?

Regards,

Andrea