Forum Discussion

MuhammadSiddiq's avatar
MuhammadSiddiq
Frequent Visitor
8 years ago

Employee Turnover

Hello,   I am needing help in clculating employee turnover to show monthly trend. The formula used to calculate turnover is like this, suppose if we want to calculate the turnover for the month of ...
Need Help
MuhammadSiddiq's avatar
MuhammadSiddiq
Frequent Visitor
8 years ago

Hey Lydia,

 

Thanks for the solution its works. But whan will be solution if the data is available in two seperate table one is of ACTIVE EMPLOYEE and the other one is of SEPARATED EMPOYEE and both are uploaded to data model then how we can calculate the same turnover by using the same formula. Below are the sample table for you reference.

 

Name          Month          Status

AlexJanActive
MariaFebActive
MariaFebActive
MariaFebActive
SidFebActive
ZahidMarchActive
ZoeMarchActive
ZeusMarchActive
KahisfAprilActive
KahisfAprilActive
CarolAprilActive
MartinMayActive
WickMayActive
Ricku\yMayActive
RexJuneActive
TedJuneActive
JulianaJuyActive
JuliaJuyActive
ArmanAugustActive
ArmanAugustActive
NancySeptActive
MatthewSeptActive
BelaOctActive
BettaNovemberActive
OliverNovemberActive

 

Name              Month            Status

SiddiqJanSeparated
SahidFebSeparated
JohnFebSeparated
JohnyMarchSeparated
TerryAprilSeparated
MartinMaySeparated
LutherJuneSeparated
KatherineJuySeparated
WilliamsAugustSeparated
BonySeptSeparated
BrettaOctSeparated
CarlaNovemberSeparated

 

 

Looking for a solution from you for making it dynamic.

 

 

Regards,

Muhammad Siddiq

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Can you just use an Append query to append the two tables together or is there a reason you need them in two separate tables?

  • MuhammadSiddiq's avatar
    MuhammadSiddiq
    Frequent Visitor
    8 years ago

    Hey Smoupre,

     

    I can append both tables together also there is no special reason to use both tables separate. The only reason for using both tables separated is to build relationship and to make the formula more dynamic and functioning. The calculated measure can work for both Month slicer and year slicer also.

     

     

    Looking forward some magic from you guys.

     

    Regards,

    Muhammad Siddiq

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      MuhammadSiddiq,

      Please help to post expected result based on the new sample tables you shared.

      Regards,
      Lydia

      • MuhammadSiddiq's avatar
        MuhammadSiddiq
        Frequent Visitor
        8 years ago

        okay i am attaching shortly