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...
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...
This is the third bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. Today's bonus exercise takes...
This is the second bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. In Chapter 5 you learn how to...
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...