Calculate new employees per month
Hey there, I am trying to create a visual with the new employees for each month. Positions can occur several times but not at the same time. For example Position P-10057. ValidFrom ValidTo FullTimeEquivalent PositionId 31.12.2023 31.12.2154 0.2 P-10016 01.12.2012 31.12.2154 1 P-10017 18.01.2016 31.12.2154 1 P-10055 01.09.2017 31.12.2154 1 P-10056 01.02.2023 31.12.2023 1 P-10057 30.06.2024 14.10.2024 1 P-10057 14.11.2023 29.02.2024 1 P-10058 31.07.2024 31.12.2154 1 P-10058 01.08.2021 04.06.2024 1 P-10059 01.08.2022 30.07.2025 1 P-10060 01.08.2022 31.07.2025 1 P-10061 15.08.2022 13.08.2025 1 P-10062 01.08.2023 30.07.2026 1 P-10063 01.08.2023 08.05.2024 1 P-10064 01.08.2021 04.06.2024 1 P-10065 I use the following Dax: FTE_Onboarding = CALCULATE( SUM(PositionWorkerAssignmentsV2[FullTimeEquivalent]), FILTER( PositionWorkerAssignmentsV2, PositionWorkerAssignmentsV2[ValidFrom] >= MIN(DateTable[Date]) && PositionWorkerAssignmentsV2[ValidFrom] <= MAX(DateTable[Date]) ) ) The datetable goes from 2022 to 2026. So the missing FTE before 2022 are correct. However I am get the following result: FTE_Onboarding Year Month 3 2022 August 1 2023 Februar 2 2023 August 1 2023 November So the FTE from Dec 23 and the two FTE from 24 are missing. Looking forward to your answers 🙂