by Gil Raviv | Jul 31, 2019 | Uncategorized
Follow @gilra 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 all the pairs of tasks of the same resource and even used the M function Table.Buffer to accelerate...
by Gil Raviv | Jul 22, 2019 | Uncategorized
Follow @gilra 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 through the solution in details. The Challenge Your input data is a table with start and end dates...
by Gil Raviv | Jul 16, 2019 | Uncategorized
Follow @gilra 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 filtering on each combination of paired records. In this article, you will learn how to apply this...
