In this blog post, we’ll take a look at how you can extract values from records and lists using power query. As you can see, the first column in my table contains records. You may watch the full video of this tutorial at the bottom of this blog. When I click off to the side
Tag: Power BI Query Editor
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.
I want to introduce you to one of the best Power BI external tools that Steven McGuire from the Enterprise DNA forum and I put together to help you with your structured practice. You may watch the full video of this tutorial at the bottom of this blog. I’ve talked a lot about structured practice,
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
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.