Forum Discussion

Michalison's avatar
Michalison
Icon for Helper II rankHelper II
4 years ago

Employee T/O measures

Hi I need some help - I am doing a dashboard and one of the things I need to do is get the T/O percentage of employees who have resigned by average current employees - this is what I have got so far ...
Need Help
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

Michalison 

Without data and the expected results, it a bit hard to propose a solution. any how can you try this and revert.

CountResignations =
VAR _DATE =
    DATE ( 2021, 1, 1 )
RETURN
    CALCULATE (
        COUNTROWS ( Personnel_Records ),
        'Personnel_Records'[Resignation] = 1,
        'Personnel_Records'[Leaving Date] > _DATE
    )

 

Michalison's avatar
Michalison
Icon for Helper II rankHelper II
4 years ago

Yes I will try this and see if there is a difference thank you