Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculating Average Value using Beginning and Ending Value

I have the following three piece measures CurrentHC = CALCULATE(SUM(HeadCountActuals[ActualPeopleCount])) PreviousHC = CALCULATE (     SUM( HeadCountActuals[ActualPeopleCount] ),     'HeadC...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

     

    Average HC = 
var a = ADDCOLUMNS(VALUES(Headcount[Month]),"CHC",var m=[Month] return CALCULATE(sum(Headcount[HC]),Headcount[Month]=m))
var b = ADDCOLUMNS(a,"PHC",var m=[Month] return if([Month]=0,[CHC],CALCULATE(sum(Headcount[HC]),Headcount[Month]=m-1)))
return averagex(b,DIVIDE([CHC]+[PHC],2,0))

     

     

     

lbendlin's avatar
lbendlin
Super User
3 years ago

 

Average HC = 
var a = ADDCOLUMNS(VALUES(Headcount[Month]),"CHC",var m=[Month] return CALCULATE(sum(Headcount[HC]),Headcount[Month]=m))
var b = ADDCOLUMNS(a,"PHC",var m=[Month] return if([Month]=0,[CHC],CALCULATE(sum(Headcount[HC]),Headcount[Month]=m-1)))
return averagex(b,DIVIDE([CHC]+[PHC],2,0))