In this tutorial, you’ll learn how to handle missing data in a currency rates table using DAX and power query. You’ll learn the different ways to manage the missing rates in your table and present them effectively in a dashboard in Power BI. You may watch the full video of this tutorial at the bottom
Tag: Power Query
In this blog post, we’ll take a look at how you can extract values from records and lists using power query. As you can see, the first column in my table contains records. You may watch the full video of this tutorial at the bottom of this blog. When I click off to the side
I’d like to present the best practices I’ve adopted while preparing Power BI reports. Over the past few years, I’ve consumed many online resources on data loading and transformation which have been instrumental in my journey, but I’ve quickly become overwhelmed by the content, so I ended up making my own notes. You may watch
In this blog post, I’ll go over problem #2 from the ongoing Problem of the Week at the Enterprise DNA forum, where we discussed how to sort messy data into a clean dimension table. This is the second iteration of this new initiative that we’re hosting at Enterprise DNA. I’m especially passionate about this series
In this blog post, we’ll take a closer look at a custom function for text cleaning that I created for our ongoing series at Enterprise DNA TV called Problem of the Week. You may watch the full video of this tutorial at the bottom of this blog. For week #2, we have a messy data