how to calculate FTE

[Anonymous]

Hi I have a workagreement table where is start date ,end date, mode of employment and expected workhours. If employment mode is full time the FTE is 1. If it is parttime then it it amount of hours divided by 37.5 hours.

At firs tough I need to filter startdate <= today, enddate >= today OR Blank. I just can't get this right.

I have tried something like
FTE= IF(EmplMode = "parttime", calculate(weeklyhours/37.5), enddate >=today() || BLANK() && startdate <=today, IF(...

ID	Startdate	Enddate	EmplMode	weekhours	FTE
	1.1.2022		Fulltime	37.5	1
	2.1.2022	15.9.2022	Parttime	25	0,66
	3.1.2022	1.6.2022	Fulltime	37.5	filtered out due to end date

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please have a try!

Create a column.

Column =
VAR _a = 'Table'[weekhours] / 37.5
RETURN
    IF (
        'Table'[EmplMode] = "Fulltime"
            && 'Table'[Enddate] >= TODAY ()
            || 'Table'[Enddate] = BLANK (),
        "1",
        IF (
            'Table'[Enddate] <= TODAY (),
            "filtered out due to end date",
            IF ( 'Table'[EmplMode] = "Parttime", FORMAT ( _a, "" ), BLANK () )
        )
    )

If I have misunderstood your meaning, please provide more details with youe desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Anonymous  works like a charm :). thousand thanks for your help 🙂

[YukiK]

This may do it!

FTE Measure = 
VAR __Today = TODAY() 
VAR __WeekHrs = SELECTEDVALUE('Table'[weekhours])
VAR __EmpMode = SELECTEDVALUE('Table'[EmplMode])
VAR __StartDate = SELECTEDVALUE('Table'[Startdate])
VAR __EndDate = SELECTEDVALUE('Table'[Enddate])
VAR __Fulltime = 
SWITCH( 
    TRUE(),
    ISBLANK(__EndDate), 1,
    __EndDate < __Today, "	filtered out due to end date"
)
VAR __Parttime =
DIVIDE( __WeekHrs, 37.5 )

VAR __FTE = 
SWITCH( 
    TRUE(),
    __EmpMode = "Fulltime", __Fulltime,
    __EmpMode = "Parttime", __Parttime
)

RETURN 

__FTE

[Anonymous]

Hi @YukiK and thanks :). This is close but for some reason I'm getting only the __parttime as a result and I need a sum of those FTE's. Also seems that End date <today not filtering. (Picture below Osa-aikainen stands for the "Parttime" in Finnish)

the table I'm working on has these values, so the FTE should be 9,67

[YukiK]

Are those dates categorized as date? We need to make sure that's in place. Otherwise, if you could again list the conditions, I can try to see what might be wrong! 🙂