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.
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
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 |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |