Tag: advanced editor power query

Power Query Transform Column Challenge: Stacked Data to Ordered Table

Power Query Transform Column Challenge Stacked Data to Ordered Table - Enterprise DNA

This blog will examine the Stacked to Ordered Data Challenge from Excel BI, involving the Power Query transform column to table functions. The task is to turn a single column of data into a proper table where each type of data has its column and subsequently will add a rank on population. You can watch

Continue reading

Power BI Parameters Via Query Editor

Creating And Using Parameter

In this tutorial, we’ll discuss how we can create and use Power BI Parameters which is a powerful feature of the Query Editor.  There are instances when we want to put additional filters on our data within the query editor. We can do that by utilizing the Manage Parameters option within the Home ribbon. For this

Continue reading

Microsoft Power Query Tutorial On How To Fix Mixed Fixed Column Width Issues

Mudassir: For today, we have a very interesting problem to work with. The problem with this file is that it is fixed delimited by columns and I don’t know how to resolve this using Microsoft Power Query. You can watch the full video of this tutorial at the bottom of this blog. First, it wasn’t

Continue reading

Enter Data In Power BI: How To Use It For Data Entry

Enter Data In Power BI: How To Use It For Data Entry

In this blog post, I want to take a closer look at the Enter data in Power BI and show you ways how to use it. Before, in most cases, we brought in data by connecting to a data source. That won’t change of course, but Power BI also offers ways to manually create tables,

Continue reading

How To Use Power Query Row And Column Selection

How To Use Power Query Row And Column Selection

This tutorial will discuss how to use selection and projection inside the Power Query Editor. Selection is for selecting a row; projection is for selecting a column. You’ll learn and understand how to use them to obtain data and information from a table. How To Use Power Query Row Selection The positional index operator is

Continue reading