Employee tenure

    0

    0

    Keivan Work

    The above code calculates the ramp up percentage for a given map based on the number of fact people per period. If the number of fact people per period is "5", the code returns "Ramped up". If the number of fact people per period is "1", the code returns "Ramping". If the number of fact people per period is "2", the code returns "Ramping". If the number of fact people per period is "3", the code returns "Ramping". If the number of fact people per period is "4", the code returns "NA".

    Employee Tenure =
    ROUNDDOWN(
      DIVIDE(
        DATEDIFF(MAX('Lookup - Employee'[Start Date]),
        TODAY(),
          DAY),
          30.437),
          0
          )
    Codiga Logo
    Codiga Hub
    • Rulesets
    • Playground
    • Snippets
    • Cookbooks
    soc-2 icon

    We are SOC-2 Compliance Certified

    G2 high performer medal

    Codiga – All rights reserved 2022.