Calculate Employee Scheduled Hrs Until Resignation Date

[_Melenios_]

Hi amazing team,

Need some of your expertise with the following issue.

I have Table1 that holds generic employee info and a specific "ResignDate" column( which is blank if N/A).

Then i have Table2 which holds "scheduled_Hrs" for the employees for each date.

What i'd like here since i have schedules for a 6 months (or more) period,  is to have a measure that sums the Hrs and  also counts scheduled days  only until the employee's "ResignDate" (if that exists in Table1.) otherwise return the sum Hrs and Count days as normal.

Thanks in advance for any sugestions!

[johnt75 · Accepted solution]

Try

Hours until resign =
SUMX (
    FILTER (
        'Table2',
        VAR ResignDate =
            RELATED ( 'Table1'[Resign date] )
        RETURN
            ISBLANK ( ResignDate )
                || 'Table2'[Date] <= ResignDate
    ),
    'Table2'[Scheduled hours]
)

[_Melenios_]

Thanks @johnt75