Tag: Data Transformation

Power BI Power Query: Removing Duplicate Rows

In this blog, I’ll show you how to remove duplicate rows in the Power BI Power Query based on conditions. You may watch the full video of this tutorial at the bottom of this blog. This example is from a question that was raised on the Enterprise DNA Forum. The member has transactional data and

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

The Importance Of Power BI Date Tables

The Importance Of Date Tables In Power BI Enterprise DNA

When working on Power BI date tables, it’s important to know the essential techniques so you can set things up as quickly as possible. In this tutorial, I’ll go over some important tips that can help you. The date tables are important in Power BI because you’ll need them to reference dates inside your model.

Continue reading

Advanced Transformations In Power BI

Let me discuss some advanced transformations in Power BI through the query editor. You may watch the full video of this tutorial at the bottom of this blog. Remember that you can combine different actions within the query editor to fully optimize your models. It’s just a matter of familiarizing yourself with the different transformations

Continue reading

Creating A Date Table In Power BI

The importance of creating a date table in Power BI is something that people often miss, especially in the Enterprise DNA forum. You may watch the full video of this tutorial at the bottom of this blog. Although it’s common to have a date column in your sales tables and transaction tables, that won’t be

Continue reading