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
Tag: Power Query M Functions
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
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
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
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