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

     

Vvelarde's avatar
Vvelarde
Community Champion
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

 

andreaaizza's avatar
andreaaizza
New Member
9 years ago

Vvelarde Thanks, this solved perfectly!