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...
Pie Charts
I am going to publish a new series soon. The first post will be about Pie Charts. I cannot share more at this stage, but I would really appreciate your...
Power BI Template Apps Exploration Tool
Since the release of Power BI Template Apps, more than 50 new apps have joined the marketplace. It's about time we would be able to search for template...
A new facebook connector error
Update (Sep 24th): I am sorry but there is no ETA yet to resolve this problem. Microsoft is working with Facebook to return this functionality ASAP (Source...
#1 Power BI Template App on AppSource
Earlier this month my template app Facebook Pages - Basic Analysis was featured here in Microsoft's official monthly feature summary for Power BI Desktop. I...
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...
