Forum Discussion

Egemeny's avatar
Egemeny
Frequent Visitor
7 years ago
Solved

Employee Turnover Calculation

Hi everyone, I'm new here and hope you can support me on this. I'd like to achieve a result where i can be able to see Employee (Staff)Turnover in monthly, quarterly and yearly basis. Can you ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Egemeny 

    You could create new measures with DAX function "TOTALMTD","TOTALQTD","TOTALYTD" to evaluate the "month to date", "quarter to date" "year-to-date" value of the expression in the current context.

     

    There is a quick way by new quick measure.

    Select three dots of a table and select "new quick measure", from the pop window, select Time Intelligence->year-to date total,,ect.

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Egemeny 

You could create new measures with DAX function "TOTALMTD","TOTALQTD","TOTALYTD" to evaluate the "month to date", "quarter to date" "year-to-date" value of the expression in the current context.

 

There is a quick way by new quick measure.

Select three dots of a table and select "new quick measure", from the pop window, select Time Intelligence->year-to date total,,ect.

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.