Forum Discussion
Power Pivot dax measures
Hi All, i am new to Power Pivot dax measures, Can any one help me to how to 1) calculate Active Head count(Formula mentioned below), 2) Avg Head count, 3)12 month Head count,4) same period last year...
amitchandak
Super User
Super UserHitumastert , refer to this blog of you have dates -
Avg headcount would be = AverageX(values('Date'[Date]), [Current EMployees])
If you follow the blog