Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

WORKER EVOLUTION

Hello! I want to make a visual with the evolution of the workers in my company. I have a Employment_Date column and a Termination_Date column (if it's empty the worker is still active) And I ha...
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi,

    It seems you are on the right track, but what about changing the min to max as there is no reason there should be both min and max in the headcount formula.  Please try swapping min with max and you will get the right output, I suppose.  

    Best regards,

DataNinja777's avatar
DataNinja777
Super User
2 years ago

Hi,

It seems you are on the right track, but what about changing the min to max as there is no reason there should be both min and max in the headcount formula.  Please try swapping min with max and you will get the right output, I suppose.  

Best regards,

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Hello again, I have just seen an error that comes out with this formula: the employees who are registered in the month of May do not appear to me, I imagine that they will be in arrears, but could I add something to my formula so that each employee appears at the time of registration, even if it is the same day?

I'm using this formula:

Employees by year evolution = CALCULATE(COUNTROWS('1-RRHH TOP MANAGEMENT'),FILTER('1-RRHH TOP MANAGEMENT',[Employment_Date]<MAX('Contract calendar'[Date])&&([Termination_Date]>MAX('Contract calendar'[Date])||[Termination_Date]=BLANK())))