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
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
In today’s blog post, I’m going to show you a tip on how I create a last refresh date and time so that I can show it on all of my Power BI reports. You may watch the full video of this tutorial at the bottom of this blog. Most of my clients say that
