Average Number of Employees in A month

DAX DAX Calculations
1

Hello,

I am trying to calculate the average number of employees in a month. I was able to have it calculated at any point in time previously.
However, how can I try to do an average on this?

image
image946Ă—451 15.8 KB

AvgEnrolled.pbix (138.6 KB)

1 Like
2

Hello @supergallagher25 ,

please see if attached fulfills your needs.

Cheers,
Seb

AvgEnrolled.pbix (138.6 KB)

1 Like
3

Thank you for taking the time to answer this @Slipper :slight_smile:

Hi @supergallagher25 , did the response provided above help you solve your query?

If not, how far did you get and what kind of help you need further?

If yes, kindly mark as solution the answer that solved your query.

1 Like
4

Hi @supergallagher25 we’ve noticed that no response has been received from you since Oct 8.

We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

5

Hi @EnterpriseDNA,
I think this was meant to be for @supergallagher25.

Cheers,
Seb

6

Thank you so much for pointing it out.
Yep, tagged the wrong person.

By the way, thank you so much for the PBIX solution you sent above :slight_smile:

1 Like
7

Hi @supergallagher25, due to inactivity, a response on this post has been tagged as “Solution”. If you have any concern related to this topic, please create a new thread.

8

Thank you this worked.

1 Like
9

My apologies for the late response, I had an issue trying to log back in.