Tag: Power BI Query Editor

Extract Values From Records And Lists In Power Query

Extract Values From Records And Lists In Power Query

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

Continue reading

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

Power BI External Tools – Installing Practice Dataset

Power-BI-External-Tools-–-Installing-Practice-Dataset

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,

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

Power BI Query Editor: Row & Column Transformations

Power BI Query Editor Row and Column Transformations

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.

Continue reading