Tag: Advanced Editor

Power Query: How To Merge Tables W/Different Columns

Power Query How To Merge Tables with Different Columns

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

Continue reading

Extended Date Table Power Query M Function

Extended Date Table Power Query M Function

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

Continue reading

Dimension Table In A Text File: Power Query Solution

Dimension Table In A Text File: Power Query Solution

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

Continue reading

Creating A Custom Text Cleaning Function In Power Query

Creating-A-Custom-Text-Cleaning-Function-In-Power-Query

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

Continue reading

Last Refresh Date & Time In Power BI – Updated Solution

Last-Refresh-Date-Time-In-Power-BI-–-Updated-Solution

In this blog post, I’ll make an update to the Last Refresh Date and Time blog post where I showed you how to insert the last refresh into your Power BI reports so you or your clients can see it. I’ve done a little research on this to try and make things simpler. You may

Continue reading