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
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
We’re going to talk about some of my best practice tips using Advanced Editor inside Power BI. Surprisingly, most people don’t know about the Advanced Editor. It is because it’s hidden away inside the Query Editor, which a lot of users don’t utilize as much as they should. If you don’t know what it is, you
