Tag: power query editor

Using Power Query Group By In A Data Challenge

Using Power Query Group By In A Data Challenge - Enterprise DNA

In this Power Query tutorial, we’ll examine a unique and intriguing Power Query Group By Alphabets to Columns Excel BI Challenge. It involves turning a single-column table into a table where each letter has its column and is repeated as often as it is present in the source table. You can watch the full video

Continue reading

Remove Empty Columns In Power BI

Remove Empty Columns In Power BI - Enterprise DNA

This blog will demonstrate how to automatically remove all empty columns in Power BI through the Power Query editor. The approach will involve the standard Table.Profile M library function and its additional aggregates parameter to add a non-empty count column. You can watch the full video of this tutorial at the bottom of this blog. Sample Query

Continue reading

A Quick Overview On Different Power Query Tools In Power BI

A Quick Overview On Different Power Query Tools In Power BI - Enterprise DNA

Power Query is a powerful tool in data transformation. After understanding about the ribbons and panes found in the Query Editor, the next step is getting acquainted with its various features. In this tutorial, we’ll go over a quick overview on the different Power Query Editor tools that’ll assist you in organizing your data. Power

Continue reading

What Is Power Query & M Language: A Detailed Overview

What Is Power Query & M Language A Detailed Overview - Enterprise DNA

In this tutorial, you’ll learn about Power Query and the M language inside the Power BI desktop. Although there can be slight differences, you can apply the same general techniques across other Microsoft products like Excel, Analysis Services, and other Microsoft tools with an embedded Power Query Engine. What Is Power Query? Power Query is

Continue reading

Power Query: How To Quickly Add Notes

Power Query How To Quickly Add Notes - Enterprise DNA

In this post, we’ll learn different ways to add notes in Power Query, which can benefit the people who do not like to take notes. You can watch the full video of this tutorial at the bottom of this blog. Adding Notes In Power Query: Step Properties The first and easiest one is the feature they

Continue reading