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
Tag: Data Transformation
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
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,
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.
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.