Find overlapping time periods using #PowerQuery – Part 3 (Fast & Furious)
In the last post here, we walked through the steps to detect overlapping time periods and calculate their durations. We used Cartesian Product to match...
Tag: Cartesian Product
Find overlapping time periods using #PowerQuery – Part 2
In my last blog post here, I introduced the overlapping time periods challenge and shared the M queries for the solution. In today's post, we will go...
Find overlapping time periods using #PowerQuery
In Chapter 11 of my book, I introduced the Cartesian Product technique that enables you to combine two datasets in order to apply a calculation or...
