Forum Discussion

mertsch's avatar
mertsch
Frequent Visitor
10 years ago
Solved

Calculate an average from a Sum by Month

Hi Guys,    I want the average from a time Period. In one Table i have 2 Rows like this:     Date:                  Values:                 01.01.2016        100 01.01.2016        50 01.01.20...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    10 years ago

    Hi Mertsch,

     

    I have tested it on my local environment, you can add calculated column to display the month name using the DAX below
    Month = MONTH(MonthAverage[Date])

    And then create a measure
    MeasureAverage = SUM(MonthAverage[Total])/DISTINCTCOUNT(MonthAverage[Month])

    Regards,

    Charlie Liao

MartaRamos's avatar
MartaRamos
Frequent Visitor
8 years ago

I have the quantity of employee per month, need to calculate the average per month

Final Qty                  Average per month

January :100            100

February: 120           110

March:   90               105

April ::  100               95

 

Average= (Qty 1+Qty)/2

i am struggling with this , if someone can help me, :) :(