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: Bonus Exercise
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...
Preserving context from multiple worksheets – Bonus Exercise – Chapter 5 – #PowerQuery Book
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...
Preserving Context from CSV – Bonus Exercise – Chapter 5 – #PowerQuery Book
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...
Finding mismatched headers and creating a conversion table – Bonus Exercise – Chapter 4 – #PowerQuery 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...
