Calculate sum of hours from annother tabel between to dates

[Moller70]

Hi.

I have 3 tabels

1 Calender

2 Employee

3 Absenteeism

In my Calender, I have the Standard Hours per day.

In my Absenteeism I have a StartAbsenDate and StopAbsenDate

I want to calculate the sum of Standard Hours between the StartAbsensDate and StopAbsenDate per employee and use the Date from calender as a filter.

I have been trying this:

AbsenHours =

SUMX (

    FILTER (

        'XYC Absenteeism',

        'XYC Absenteeism'[StartAbsenDate] <= 'XYC Calender'[Date]

            && 'XYC Absenteeism'[StopAbsenDate]>= 'XYC Calender'[Date]

    ),

    'XYC Calender'[XYC Standard hours]

)

But I can not get i working.

Please Help.

[Idrissshatila · Accepted solution]

Hello @Moller70 ,

Check if this video would help you in your case https://youtu.be/6JA6uy3ZRBA

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin