Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to find employees that havent been qualifyed testet in the last 3 month. / who has a latest test date older than 3 month.
Table: dw Dim_Employee field: Employee_employeeID
Table: dw Fact_Quality field: DATEREG
hope some can help
br. Jens
Solved! Go to Solution.
Hi @JENS,
Please add a calculated column which returns month interval between latest test date and today for each employee.
Days =
DATEDIFF (
CALCULATE (
MAX ( 'dw Fact_Quality'[DATEREG] ),
ALLEXCEPT ( 'dw Fact_Quality', 'dw Fact_Quality'[Employee] )
),
TODAY (),
MONTH
)
Then, use this measure to count the number of employee who haven't been qualified tested in the last 3 month.
older than 3 month = CALCULATE ( DISTINCTCOUNT ( 'dw Fact_Quality'[Employee] ), FILTER ( 'dw Fact_Quality', 'dw Fact_Quality'[Days] > 3 ) )
Best regards,
Yuliana Gu
Hi @JENS,
Please add a calculated column which returns month interval between latest test date and today for each employee.
Days =
DATEDIFF (
CALCULATE (
MAX ( 'dw Fact_Quality'[DATEREG] ),
ALLEXCEPT ( 'dw Fact_Quality', 'dw Fact_Quality'[Employee] )
),
TODAY (),
MONTH
)
Then, use this measure to count the number of employee who haven't been qualified tested in the last 3 month.
older than 3 month = CALCULATE ( DISTINCTCOUNT ( 'dw Fact_Quality'[Employee] ), FILTER ( 'dw Fact_Quality', 'dw Fact_Quality'[Days] > 3 ) )
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |