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

hello Diana_Jardim100  i think a summarized table could help 
summary of table = summarize(table,[ID_EMPREGAD], "First Start Date",calculate(firstdate(dat_ini_act_emp)FILTER(table,dat_ini_act_emp = max(dat_ini_act_emp)),"Last day",calculate(lastdate(dat_said_one_hr),FILTER(table,dat_said_one_hr = max(dat_said_one_hr))

Diana_Jardim100's avatar
Diana_Jardim100
Frequent Visitor
3 years ago

First Many thanks.

I'm almost there ðŸ™‚

I don't know what I'm doing wrong but it has return this message.

The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column.

 

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

 

 

 

 

 

 

 

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    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]))))

    • Diana_Jardim100's avatar
      Diana_Jardim100
      Frequent Visitor
      3 years ago

      same error 

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Do you mind sharing some sample data to help you?