Forum Discussion

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

HI PrachiD

 

Try this

 

Try this solution.

If you donot have a column for Month Numbers... add this calculated column

 

Month_Number =
SWITCH (
    TableName[Month],
    "January", 1,
    "February", 2,
    "March", 3,
    "April", 4,
    "May", 5,
    "June", 6,
    "July", 7,
    "August", 8,
    "September", 9,
    "October", 10,
    "November", 11,
    "December", 12
)

 

Now you can use this MEASURE

 

Average =
CALCULATE (
    AVERAGE ( TableName[Count] ),
    FILTER (
        ALL ( TableName ),
        TableName[Month_Number] <= SELECTEDVALUE ( TableName[Month_Number] )
    )
)
    • PrachiD's avatar
      PrachiD
      Helper I
      8 years ago

      Thank you :smileyhappy:

    • PrachiD's avatar
      PrachiD
      Helper I
      8 years ago

      Count in the above column is of Person ID how can I manage Average and Count in same measure or Column because I want distinct count for Person ID with Moving Average