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? This refers to the extended date table from the M code showcase that was developed by Melissa Dekorte, one of our Enterprise DNA
Tag: Power Query Date Table
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. This tutorial will also teach you how to fill gaps in your data and how to harvest them in
I’m going to show you a new approach in creating a date table in Power BI. 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 efficient way to do it. This is actually an approach created by Melissa, one of
I’m going to show you how to turn an M code for a date table into a table query. I would consider the level of difficulty for this tutorial as intermediate because if you have any experience with M codes, it would be easy for you to follow along. If you don’t have any related
I’m going to show you how to add a parameter in the M function in your date table query. This example is based on a question that was raised on the Enterprise DNA Forum. The question was about how to switch the numbering of the 1st day of the week from 0 to 1. Note