question

DangodaraHiteshMumbai-7230 avatar image
0 Votes"
DangodaraHiteshMumbai-7230 asked DangodaraHiteshMumbai-7230 answered

Please help me to find Average of Active Head count using measures.

Please help me to find Average of Active Head count using Pivot Measures. Active Head Count := CALCULATE([JoinersCounts]-[leaversCounts],FILTER(ALLSELECTED('Date'[Date]),ISONORAFTER('Date'[Date],MAX('Date'[Date]),DESC))) Avg. of Active Head Count Please help me to find Avg. of Active Head Count for each month example given below. If possible please do calculation in attached excel only. ![82066-image.png][1] [1]: /answers/storage/attachments/82066-image.png

power-query-not-supported
image.png (19.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HerbertSeidenberg-6295 avatar image
0 Votes"
HerbertSeidenberg-6295 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DangodaraHiteshMumbai-7230 avatar image
0 Votes"
DangodaraHiteshMumbai-7230 answered

Dear Team,

First thank you so much for answering my query.

Can you please help me to find each month Joiners, Exits, Current Active Head Count, and Avg. Head count as department, Location and Gender wise.

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


I want Avg Head count but filter wise like (department, Location and Gender wise.).

My column. would be.

82142-image.png



image.png (29.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HerbertSeidenberg-6295 avatar image
0 Votes"
HerbertSeidenberg-6295 answered

Happy to do your data analysis each month,
but please file share your data base and
your attempted and/or desired solutions.
Use a minimum of data anonymization
Post timely and monthly.
Pictures are worthless.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DangodaraHiteshMumbai-7230 avatar image
0 Votes"
DangodaraHiteshMumbai-7230 answered

Dear sir it's possible to find active headcount using m code, if possible please help using any dumy data, as it's not allowed to attached Excel.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.