Forum Discussion

rsbin's avatar
rsbin
Community Champion
1 year ago
Solved

Find Terminated Employees

Good Day Folks, Looking for some guidance on this one.  Have the following Employee Data Table: EmployeeID PointinTimeID Status StartDate EndDate Terminated Flag 1 4840 ...
Need Help
  • ThxAlot's avatar
    ThxAlot
    1 year ago

     

    Flag =
VAR __id = EMPL[EmployeeID]
RETURN
    CALCULATE(
        NOT ISEMPTY( EMPL ),
        ALL(),
        EMPL[EmployeeID] = __id,
        EMPL[Status] = "Terminated"
    ) + 0

     

     

     

    Flag =
CALCULATE(
    NOT ISEMPTY( EMPL ),
    ALLEXCEPT( EMPL, EMPL[EmployeeID] ),
    EMPL[Status] = "Terminated"
) + 0

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

This calculated column formula works

Column = if(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[EmployeeID]=EARLIER(Data[EmployeeID])&&Data[Status]="Terminated"))>0,1,0)

Hope this helps.