Tag: Power Query Date Table

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

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

Calendar Layouts To Tabular Format Using Power Query

Tabular-Format-Using-Power-Query

In this tutorial, you’ll learn about turning multiple calendar type layouts into a tabular format using Power Query in Power BI. You’ll learn how to transform multiple files instead of a single file from a folder. You may watch the full video of this tutorial at the bottom of this blog. This tutorial will also

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