Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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,
@Hitumastert , refer to this blog of you have dates -
Avg headcount would be = AverageX(values('Date'[Date]), [Current EMployees])
If you follow the blog
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
51 | |
44 | |
16 | |
12 |