Tag: Query Editor

Power Query/M Masterclass #1 – New Course on Enterprise DNA

We’re ending June with a bang by introducing a new course on the Enterprise DNA Education Platform — the 1st of many installments of the Power Query/M Masterclass. Those who will sign up for this course is in for a real treat because Enterprise DNA Expert Melissa de Korte will be hosting this class. Those

Continue reading

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


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

Dynamic Date Slicer In Power BI Using A Period Table


In today’s blog post, I’d like to discuss what we like to call the period table. The period table creates a distinct date range so you can slice your data any way you want. I’ll show you how you can create a dynamic date slicer in Power BI by using this period table. You may

Continue reading

Power BI Unpivot Columns – Power Query Tutorial

This is a tutorial about Power BI unpivot columns. I’m going to show you how to unpivot multiple column combinations. You may watch the full video of this tutorial at the bottom of this blog. This is part of an unpivot variation series, which is all about turning your data into a proper tabular format

Continue reading