Forum Discussion

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

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

Frequent Visitor

3 years ago

same error

Anonymous
Not applicable
3 years ago
Do you mind sharing some sample data to help you?
- Diana_Jardim100
  Frequent Visitor
  3 years ago
  https://docs.google.com/spreadsheets/d/1sgWmbjgKJvVmUCT4nTIUm-_NbHryPWakT0JiYFGWGC8/edit?usp=sharing
- Diana_Jardim100
  Frequent Visitor
  3 years ago
  https://docs.google.com/spreadsheets/d/1sgWmbjgKJvVmUCT4nTIUm-_NbHryPWakT0JiYFGWGC8/edit#gid=0
  - 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])))

Forum Discussion

Need some help.

Related content

DAX Formula Help

Calculation Help

need help

DAX Query help

Help Transposing