Tag: Power BI M Code

Power BI Custom Query Functions

Power BI Custom Query Functions

For today’s tutorial, we’re going to build a Power BI custom Query function that’s going to deal with a common difficult-to-handle format of stacked data. This technique is easily reusable on multiple reports and multiple tables. You can watch the full video of this tutorial at the bottom of this blog. This is a continuation

Continue reading

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 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

DAX And Power Query | Creating Self-Sorting Columns

Subsequent to a recent DAX pop quiz that I prepared and posted on LinkedIn, one of the people who responded to the quiz raised a fascinating idea, via which text columns no longer needed a numeric sort column to put them in proper order. I experimented with this new approach and it worked beautifully. In

Continue reading