Tag: Power Query Modulo

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