Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
5 years ago
Solved

DAX calculation from a table

I am trying to do below calculation        Sum of Terms / Average Headcount as example using 1/1/20+2/1/20 ...   230+231 = 461 (Sum of Terms) 3651+3696 =7,347 / 2 =3,673.5 (average headcount) 4...
Need Help
jcastr02's avatar
jcastr02
Post Prodigy
5 years ago

Hello @Greg_Deckler I've provided an example above in screen shot using 1/1/20 +2/1/20

I should have % at 12.55% - Can you take a look at my measure below to see what is incorrect.... trying to do sum of terms / average headcount

Attrition new new.png

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

@jcastr02 - Sorry, but I am not hand typing all of that in order to mock up a model. Maybe someone else will.