Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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 Head count in Power piovt excel sheet.  and  5)Also attrition for all the above period.


Your help can save my life to manullay writing excel forumlas .

Active Head count :CALCULATE([JoinersCounts]-[leaversCounts],FILTER(ALLSELECTED('Date'[Date]),ISONORAFTER('Date'[Date],MAX('Date'[Date]),DESC)))


Attrtion forumla in excel is:(Leavers/ Avg. Headcount*12)/No of month


Please help


Frequent Visitor

No Sir This forumla is not working, as its showing current head count same as monthly Average .


I want Calculate A Monthly Moving Average Year To Date (YTD) 

This below link show how calculate correct way to do, i tried but its not working.


Can you please help me to find out A Monthly Moving Average Year To Date (YTD).


Thank you so Sir,

Super User IV
Super User IV

@Hitumastert , refer to this blog of you have dates -


Avg headcount would be = AverageX(values('Date'[Date]), [Current EMployees])


If you follow the blog


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors