Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Hitumastert
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

 

2 REPLIES 2
Hitumastert
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. 

https://www.youtube.com/watch?v=nQS6ZO45JNA

 

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

 

Thank you so Sir,

amitchandak
Super User
Super User

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

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

 

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

 

If you follow the blog

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors