Tag: Power Query M Functions

Introducing Power Query Extended Date Table V2

Introducing Power Query Extended Date Table V2 - Enterprise DNA

In today’s blog, I will briefly introduce the Extended Date Table 2.0. I first shared the code for this M function in April 2020. Since then, there have been a number of requests and updates on this Power Query date table. You can watch the full video of this tutorial at the bottom of this

Continue reading

Power Query M Language Tutorial on Projections

Power Query M Language Tutorial on Projections - Enterprise DNA

The field-access expression is used to select a value from a record or to “project” a record or table to one with fewer fields or columns, respectfully. In this Power Query M Language tutorial, we are going to delve on Projections, its meaning, and how to use it. You can watch the full video of

Continue reading

Replace Value For Matching Text In Power Query

Replace Value For Matching Text In Power Query - Enterprise DNA

If you’ve ever had a requirement to perform multiple exact text match replacements, there’s a good chance you’ve performed a series of replace value steps. But as always, there are multiple and easier ways to achieve the same result. You can watch the full video of this tutorial at the bottom of this blog. In

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

Power BI Rank and Custom Grouping

Power BI Rank and Custom Grouping - Enterprise DNA

As data analysts, we are often required to group and rank values from a data set in order to generate trends and insights. However, not everyone knows how to do these tasks the easy way using Power BI. In today’s blog, we will examine a scenario that requires Power BI rank and custom grouping functions

Continue reading