Tag: Power Query M Functions

Power Query Modulo: How To Handle Stacked Data

Power Query Modulo How to Handle Stacked Data

For this tutorial, I’m going to demonstrate how you can transform messy stacked data into a more organized format. There’s quite an easy way to do this, and it’s one that is going to be incredibly useful and has a lot of different applications. We’re going to use the Power Query modulo. You can watch

Continue reading

Power BI Tip: How To Compare First N Business Days

For this post, I would like to talk about a recent Power BI tip that I came up with for a member of the Enterprise DNA forum. The question dealt with a useful pattern in terms of looking at the first N business days or first N billable days of a given month versus the

Continue reading

Comparing Tables In Power Query | Power BI Tutorial

Comparing Tables In Power Query | Power BI Tutorial

Comparing tables is a very common task in Excel and can get tedious if you do it manually all throughout. In this tutorial, I’ll show how you can easily compare two tables in Power Query to isolate the items that do not appear on both tables and report the differences. You can watch the full

Continue reading

Using Power Query Advanced Editor To Extract Values Before A Specific Text

Using Power Query Advanced Editor To Extract Values Before A Specific Text

For this tutorial, I’m going to demonstrate how you can extract values before each occurrence of a specific text using Power Query Advanced Editor. There are many ways to achieve this, but I thought it would be fun to show a solution that’s fully coded. You can watch the full video of this tutorial at

Continue reading

Power Query Editor Tutorial: Extract Record Field Values From Lists

Power Query Editor Tutorial: Extract Record Field Values From Lists

In this Power Query Editor tutorial, I want to showcase how you can extract record field values from a nested list and combine those into a single text string. You can watch the full video of this tutorial at the bottom of this blog. A member of the Enterprise DNA Forum posted this scenario. We

Continue reading