Remove duplicates in a text string with Power Query / Power BI
A few days ago I was checking social media to find interesting…
The Power User
Technology and data preparation articles written by Miguel Escobar.
Incremental refresh for files in a Folder or SharePoint - Power BI
A few years ago I posted my first impressions on Power BI…
Split / Segment / Partition / Section your table in Power BI / Power Query
The following is a pretty common scenario that I've seen with flat…
Restructure your Columns with Power BI / Power Query
I've just finished moving from HubSpot to ActiveCampaign. While HubSpot seems to…
Step level error in Power BI / Power Query
In a previous blog post (here) I covered the types of errors…
Handling Different Time Zones in Power BI / Power Query
What time is it right now for you? We might share the…
Fill dates between dates with Power BI / Power Query
One of my most popular posts is one about recurring dates with…
Recursive Functions in Power BI / Power Query
Have you ever heard about Recursion or Recursive functions? They are present…