Tag: Power BI Query Editor

Advanced Transformations In Power BI

Let me discuss some advanced transformations in Power BI through the query editor. Remember that you can combine different actions within the query editor to fully optimize your models. It’s just a matter of familiarizing yourself with the different transformations in Power BI and finding out what scenarios they’re useful for. DOWNLOAD FILES USED IN

Continue reading

Organizing Your Queries: Power BI Query Editor Tutorial

In this quick Power BI query editor tutorial, you’ll learn how to organize your queries to create intuitive models. It’s important that your models are as intuitive as possible. Not only will this make it easier for you to work on your models, it will also make it easier for other people to jump in

Continue reading

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