Forum Discussion
Split rows by days into multiple by dates range
Hello, I have data that includes an [Job], [StartDate] and [EndDate]. The time elapsed between the [StartDate] and [EndDate] can span over multiple days. In such case, I need to split the record i...
Sorry for a non-answer....but I strongly suggest you solve this as close to source as possible, talking from experience with the same problems to solve. SQL with a recursive common table expression is prefferred. Power Query is possible also.
I do not remember exactly how I solved it with DAX. It involved keeping the structure you had in your original table, De Morgan's Law for the problem of overlapping time periods comparing a non-relational calendar with start and stop times for each day and doing subtraction against the end of the day if the periods overlapped. Was super slow and made me realize that this was not the strength of DAX.