Tag: Query Editor

Simple Power BI Transformations For More Optimized Data

I’m going to talk about simple Power BI transformations you can do around the query editor. The query editor allows you to clean up your data and transform it from its rawest form. Although it allows you to do some really advanced transformations, I want to focus on the simple ones you can do. Through

Continue reading

Change Date Formats Using The Power Query Editor

In this tutorial, we’re going to go over a quick solution on how to change date formats using the power query editor in Power BI. This is from a recent Enterprise DNA member-only event which featured the production data of an oil and gas company from a certain area in the United States. Inconsistent Date

Continue reading

Changing File Location Using A Query Parameter In Power BI

Changing File Location Using A Query Parameter In Power BI

In this tutorial, you’ll be learning how to share a file with a person that’s not part of your company using a query parameter in Power BI. The data used for this tutorial is a basic stock file containing clothes data. For this example, let’s say you’re working with a person named Bill. Bill is

Continue reading

Organizing Your Queries Into Groups In Power BI

If you have a big data set and a large number of queries, it is a must to do data cleaning. Some users don’t realize how essential data cleanup is inside the Query Editor. You can easily use the options from the Transform ribbon or simply right-click the columns. There’s absolutely no need to use

Continue reading

Row And Column Transformations In Power BI

I want to go over some of the best practices in optimizing your rows and columns inside the Query Editor. You can optimize your table so that when you create visualizations, you’ll be able to recognize your columns easily. One of the best ways to develop the most intuitive Power BI model is to simplify

Continue reading