Tag: Data Transformation

Power BI Data Transformation and Setting Up Models and Relationships

Power BI Data Transformation and Setting Up Models and Relationships

In this tutorial, I’m going to show you how I set up my models and the relationships in it. Creating a seamless flow around Power BI data transformation can greatly improve the report development process, and the way you set up your models is a primary contributor to this flow. To clearly portray my Power

Continue reading

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 $685,616.33. You can watch the full

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