Forum Discussion

Diana_Jardim100's avatar
Diana_Jardim100
Frequent Visitor
3 years ago
Solved

Need some help.

Hi everyone.  Please I need some help.   Currently I have a dataset which contains the Headcount of the company by month. I need to display the total of people that joined and left the company mo...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Ok please try 

     

    Summary = SUMMARIZE(TotalActivosSaidas,TotalActivosSaidas[ID_EMPREGAD], "First Start Date", CALCULATE(FIRSTDATE(TotalActivosSaidas[DAT_INI_ACT_EMP]),TotalActivosSaidas[DAT_INI_ACT_EMP] = MAX(TotalActivosSaidas[DAT_INI_ACT_EMP]), "Last day", CALCULATE(LASTDATE(TotalActivosSaidas[DAT_SAID]),TotalActivosSaidas[DAT_SAID] =max(TotalActivosSaidas[DAT_SAID]))))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Do you mind sharing some sample data to help you?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    is this the result you desire?

    Summary = SUMMARIZE(ALL(Diana),Diana[ID_EMPLOYEE],"Start Date",CALCULATE(MIN(Diana[INITIAL_DATE])),"End Date",CALCULATE(MAX(Diana[END_DATE])))