Tag: Data Transformation

Stock Quote App – Dynamic, Fast & Easy In Power BI

Stock Quote App - Dynamic, Fast & Easy In Power BI

In this blog, I’ll show you how to create a dynamic stock quote app in Power BI. This interesting technique came out from a post in the Enterprise DNA forum. The member wanted to know how we go about starting with online data and pulling that into Power BI and then analyzing it from there

Continue reading

Power BI Unpivot Columns – Power Query Tutorial

This is a tutorial about Power BI unpivot columns. I’m going to show you how to unpivot multiple column combinations. This is part of an unpivot variation series, which is all about turning your data into a proper tabular format that is suitable for analysis. Most transformations can be performed using the user interface. The

Continue reading

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. This example is from a question that was raised on the Enterprise DNA Forum. The member has transactional data and wants to remove rows that cancel each other out. There are two distinct transactional types,

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