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

     

ThxAlot's avatar
ThxAlot
Super User
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

 

  • rsbin's avatar
    rsbin
    Community Champion
    1 year ago

    ThxAlot ,

    Brilliant....Thanks Much!!!

    I think this works....need to test it on a much larger and complex dataset, but appreciate the novel approach.

    Best Regards,