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: Power Query
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...
My MVP 2019-2020 Award
Last week I was re-awarded as a Microsoft MVP (This is the third year now) and I am so grateful. The Microsoft Most Valuable Professional award is a unique...
PowerQuery.com and my recorded sessions at MBAS 2019
The Microsoft Business Application Summit was a blast. If you missed it, you can now watch all the Power BI session recordings here, or get a great...
Book update
Are you attending Microsoft Business Applications Summit next week? I hope you can join my session on Power Query and get a chance to win a print version of...
My Sessions at MBAS
June 11-12 are getting near, and it is this time of the year to start getting excited. Microsoft Business Applications Summit is getting close. Do you plan to...
Be a Power Platform Jedi – How to run a book raffle
This is the first blog post in a series of posts that I plan to publish and share some of my demos that I presented during the Power Platform World Tour in...
The Fill Down Hierarchies -Generic Solutions
In today's blog post, I share the generic solutions for the Fill Down challenge that I posted here. As you recall, we had a table of backlog items with...
The Fill Down Hierarchies -Solutions
In today's blog post, I will share the simple solutions for the problem that I posted here. For the recursion approach, stay tuned for Part 2 of this...
