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
In this tutorial, you’ll learn how to use Power Query for currency conversions in Power BI. The method discussed in this blog will help you solve problems in your currency rates table using the last available rate. You’ll understand how to work things out when the currency rates table doesn’t have a currency rate on
In this tutorial, we’re going to learn how to unpivot columns in Power BI, and understand the importance of doing it inside our data models. When working on data inside Power BI, we generally want it to be in an unpivoted format. This is the most optimized way a table can be set up for
In this tutorial, we’ll discuss essential transformations within Power BI Query Editor that can be used to optimize your rows and columns. In developing an intuitive Power BI model, it’s best to simplify your rows and columns inside your table. Optimizing your table is essential in creating visualizations, so you can easily recognize your data.
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