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 | Dec 7, 2018 | Book
This is the third bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. Follow @gilra Today’s bonus exercise takes you to an advanced challenge after you complete Chapter 5. You are not required to go through...
by Gil Raviv | Nov 15, 2018 | Book, Power BI, Power Query
This is the second bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. Follow @gilra In Chapter 5 you learn how to preserve context from titles in the worksheet grid after you combine multiple tables, as...
by Gil Raviv | Oct 26, 2018 | Book
This is the first post of a series of bonus exercises that will accompany my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. The topics of these bonus exercises will usually cover areas that are already discussed in the book. They...
