Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a sick leave table like below. I want to check if an employee has submitted any sick leave request that overlap with another request. E.g.,, in the table below, employee id 25, submitted one sick leave request starting from 2018-01-15 to 2018-02-15, then another request starting from 2018-02-11 to 2018-07-24. clearly the 2nd request partially overlaps witht the first request. How to create a DAX column to check these overlapping cases?
I have tried if() + earlier() function, it looks earlier() only works with filter functions.
Solved! Go to Solution.
@Anonymous , In the past I Solved overlapping problem. See if this file can help
https://www.dropbox.com/s/1mlq21o1xjuw8il/overlappingdates.pbix?dl=0
@Anonymous , In the past I Solved overlapping problem. See if this file can help
https://www.dropbox.com/s/1mlq21o1xjuw8il/overlappingdates.pbix?dl=0