Power Query is a powerful tool in data transformation. After understanding about the ribbons and panes found in the Query Editor, the next step is getting acquainted with its various features. In this tutorial, we’ll go over a quick overview on the different Power Query Editor tools that’ll assist you in organizing your data. Power
Tag: Advanced Editor
In this post, I’m going to show you how to do a conditional merge of tables in power query. For this particular example, we can actually do it the normal way, which is what we are going to start with. Then I will show you how to do a conditional merge. Let’s see what we’re
In today’s blog post, we’ll take another look at the Power Query M function for the extended date table. Since initially posting the code, there have been a number of updates with the help of our Enterprise DNA community. It has grown into quite an extensive date table that pretty much covers everything you’ll likely
In this blog post, I’ll go over problem #2 from the ongoing Problem of the Week at the Enterprise DNA forum, where we discussed how to sort messy data into a clean dimension table. This is the second iteration of this new initiative that we’re hosting at Enterprise DNA. I’m especially passionate about this series
In this blog post, we’ll take a closer look at a custom function for text cleaning that I created for our ongoing series at Enterprise DNA TV called Problem of the Week. You may watch the full video of this tutorial at the bottom of this blog. For week #2, we have some messy data