Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to calculate the employee count (FTE) based on the start(hire) date, end(terminate) date, and also considering the partial number of days worked in a month. I have put the information in a table to demonstrate that I am trying to achieve the numbers in the blue cells. I have an Employee table and a Date Table in my Power BI file where there is an active relationship between the Date Table-date and Employee table-start date and an inactive relationship between date Table-date and Employee table-end date.
I will be grateful if someone can help me with creating the right measure for calculating the "Total days worked" in a Month for each employee and the "FTE per month"
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
I suggest having a disconnected DATE Table like below.
All measures are in the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picture and the attached pbix file.
I suggest having a disconnected DATE Table like below.
All measures are in the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
One small question, if I want to calculate the YTD value for both Total Days Worked and FTE measure, should I create an inactive relationship between Date Disconnected table and Employee table and then use USERELATIONSHIP function?
I tried creating the YTD measure without any relationship but it is not working.
Hi,
Can you let me know the expected outcome?
Because I decided to use a disconnected date table, I think the measure has to be written differently than using the time intelligent function.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, sorry for bothering you again, do you think this can be done?
I attached a sample outcome in my last response.
This is the YTD value I need to generate.
Thank you again for responding.
Thank you so so much for your generous help and for putting the effort into this.