Guest Story: Maintain a simple database with Power Query
Our guest today is Kolyu Minevski, Director, Financial Management and Reporting at Fadata Group. You can contact him here. This article will demonstrate...
Tag: Power Query
Guest Story: Unpivot Pairs of Columns
Our guest today is Sandeep Pawar. A Simulation & Data Analytics Engineer at Cree Lighting in Racine, WI. Sandeep applies Data Analytics, Statistics, and...
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...
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...
