Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count Employee allocations

I have allocation records, where an employee is allocated to various clients & the employee works at diff departments within the client, employees may be rotated or extended to another task within th...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Try to create a new column like below:

    status_1 = 
 var rank_ = 
 RANKX(
     FILTER('Table',
        EARLIER('Table'[EmpID])='Table'[EmpID]&&
        'Table'[Client]=EARLIER('Table'[Client])
    ),
    'Table'[Start Date],,ASC,Dense)
return IF(rank_=1,"New Allocation
","Extension")

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Note: in Base records the status column is not there, I am looking to create that column, 

I tried using group by EmpID, got the count of entries for each emp but I am clueless what to do next, please help

V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Try to create a new column like below:

status_1 = 
 var rank_ = 
 RANKX(
     FILTER('Table',
        EARLIER('Table'[EmpID])='Table'[EmpID]&&
        'Table'[Client]=EARLIER('Table'[Client])
    ),
    'Table'[Start Date],,ASC,Dense)
return IF(rank_=1,"New Allocation
","Extension")