Tag: Power BI M Code

Unpivot Multiple Columns Dynamically In Power BI

Unpivot Multiple Columns Dynamically In Power BI

In this tutorial, we’ll revisit a topic I covered earlier about how to unpivot multiple columns in Power Query using List.Zip. An Enterprise DNA member asked on the forum on how to make that method dynamic. You may watch the full video of this tutorial at the bottom of this blog. I’ve labeled this advanced

Continue reading

Power Query M: Alternating 0-1 Pattern In Date Table

Power-Query-M-Alternating-0-1-Pattern-In-Date-Table

This tutorial focuses on using the Power Query M number.mod function to create an alternating 0-1 pattern in the Date table. The solution that I’m going to show you came from one of our community power users, Rajesh, at Enterprise DNA. You may watch the full video of this tutorial at the bottom of this blog.

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

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

Create a Perpetually Updated Practice Dataset in Power BI

I’m going to show you how to keep your practice dataset updated every time you do a refresh. You may watch the full video of this tutorial at the bottom of this blog. If you really want to improve your DAX skills, the way way is to use it and put it into practice. And

Continue reading