How to Calculate Total Population Employe in every month

[Fia_Fiia]

Hi,

Please Help me, I want search total population employee with, but how can I make the name of the new employee in the following month not appear so that every time I choose a month, the population will appear that month, this formula that I use but is not yet valid

=Count(DISTINCT{<year = ,month = ,status = ,MQ = ,Product = ,[Employee Status]={'*'}-{'Non Active'} >}Populasi)

this is a formula that only raises employees not logged in that month and for the next new employee it still appears. how to prevent new employees from appearing next month. Take my example in February but new employees in March and April also appeared:

=Count(DISTINCT{<year = ,month = ,status = ,MQ = ,Product = ,[Employee Status]={'*'}-{'Non Active'}>}Populasi)-count(DISTINCT idnumber_fto)

Thank you

[Arthur_Fong]

Can you provide a sample app that shows what is the current result shown in the expression vs the expected result that should be displayed?

[Fia_Fiia]

Hello, This is what I want expected result 😊

[Surya]

Hello.,

Take stright table and 

diemsion As Month and

Expression as Count of emp

[Arthur_Fong]

Do you have the join date detail in your table?

[Fia_Fiia]

Spoiler

Yes, I have

[Fia_Fiia]

Allready, but the new emp id still calculate

[Arthur_Fong]

Can you please populate the join date detail into the sample excel as well?

[sunny_talwar]

May be this

=Count(DISTINCT{<year, month = {"<=$(=Max(month))"}, status, MQ, Product,[Employee Status] = {'*'}-{'Non Active'}>} Populasi) - Count(DISTINCT idnumber_fto)

Here I am assuming that month is defined as a number in your script based on the sample provided

 

[Fia_Fiia]

Still not work and error ....  🤔