Tag: M Code

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

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

Sorting Date Table Columns In Power BI

Sorting Date Table Columns In Power BI

In today’s blog, I’ll discuss a question that comes up all the time in the Enterprise DNA forum. How can you can sort the fields from an extended date table columns properly? You may watch the full video of this tutorial at the bottom of this blog. This refers to the extended date table from

Continue reading

Creating A Date Table In Power BI The Fastest Way Possible

Enterprise DNA Power BI Video Tutorial Create a Detailed Date Table Fast

I’m going to show you a new approach in creating a date table in Power BI. You may watch the full video of this tutorial at the bottom of this blog. I’ve done so many tutorials about creating date tables over the years, but the new method I’m using now is, by far, the most

Continue reading

Convert The Date Table Function Into A Table Query In Power BI

I’m going to show you how to turn an M code for a date table into a table query. You may watch the full video of this tutorial at the bottom of this blog. I would consider the level of difficulty for this tutorial as intermediate because if you have any experience with M codes,

Continue reading