Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Calculating monthly Headcounts and FTE's

  • 1.  Calculating monthly Headcounts and FTE's

    Posted 27 days ago
    Edited by bhargav reddy 27 days ago
    Hi All, Please check the sample data snip below .Here i need to calculate monthly FTE's  and need to compare those monthly FTE's for the past 2 years.
    If you see the Person Id - 2211, we can see three different FTE's for that person. So when i am calculating  the sum of FTE's it was adding all the three FTE's , but i need to select only one FTE based on that date.

    Can you please someone guide me for this


    Here my Measures for Headcount & FTE's:
    Total HeadCount =
    CALCULATE(DISTINCTCOUNT('ADE Data'[Person Number]),
    FILTER(VALUES('ADE Data'[Starting Date]),'ADE Data'[Starting Date]<= LASTDATE('Calendar View'[Date].[Date])),
    FILTER(VALUES('ADE Data'[End Date]),OR('ADE Data'[End Date]>LASTDATE('Calendar View'[Date].[Date]), ISBLANK('ADE Data'[End Date]))))

    Total FTE =
    CALCULATE(SUM('ADE Data'[Career History.FTE]),
    FILTER(VALUES('ADE Data'[Starting Date]),'ADE Data'[Starting Date]<= LASTDATE('Calendar View'[Date].[Date])),
    FILTER(VALUES('ADE Data'[End Date]),OR('ADE Data'[End Date]>LASTDATE('Calendar View'[Date].[Date]), ISBLANK('ADE Data'[End Date]))))





    Many Thanks in Advance


    ------------------------------
    bhargav reddy
    ------------------------------