Tag: Advanced Editor

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 a 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

Show Last Refresh Date/Time In Your Power BI Reports

Show-Last-Refresh-DateTime-In-Your-Power-BI-Reports

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

Continue reading