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...
Category: Power BI
Bad Practices in Power BI: A New Series & the Pie Chart Prologue
DataChant is launching a new series that will focus on bad practices in Power BI. Instead of sharing with you tips & tricks on how to deliver...
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...
