Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am trying to create a measure to capture all new hires that leave within 90 days of their hire date using the difference between the hire date and termination date.
I tried to use DATEDIFF, but when I start typing my table and column name it will only pull measures I've created.
Any help appreciated!
Solved! Go to Solution.
@Anonymous ,
You can just add an aggreagation function to the column like MAX()
Result = DATEDIFF ( MAX ( Table[StartDate] ), MAX ( Table[EndDate] ), DAY )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
You can just add an aggreagation function to the column like MAX()
Result = DATEDIFF ( MAX ( Table[StartDate] ), MAX ( Table[EndDate] ), DAY )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The first argument of DATEDIFF is a specific value so you need to wrap your date column in a function such as FIRSTDATE or MIN. Take a look at the pattern in this article which is close to what you are trying to achieve:
User | Count |
---|---|
92 | |
87 | |
77 | |
73 | |
68 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |