Tag: Data Transformation

Format Data In Power BI: Addressing Irregular Data Formats

Format Data In Power BI- Addressing Irregular Data Formats

In today’s blog post, we’ll discuss Problem of the Week #6. I’ll show you how to format data in Power BI involving the use of power query. The screenshot below is the solution that you should have after you’ve done all the data transformation. The actual balance number was at $685,616.33. You may watch the

Continue reading

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. You may watch the full video of this tutorial at the bottom of this blog. The member wanted to know how we go about starting

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. You may watch the full video of this tutorial at the bottom of this blog. This is part of an unpivot variation series, which is all about turning your data into a proper tabular format

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. 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