Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
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,

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Hello again, I just saw an error that I get with this formula: I have two employees discharged in May and they don't appear in the graph, does anyone know why?

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())))