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 can watch the full video of this tutorial at the bottom of this blog. When I click off to the side
Tag: Data Model Power BI
In this tutorial, you’ll learn how to properly create and set up the data model for inventory management dashboards in Power BI. Before you start working on the DAX formulas and visualizations, make sure to check if your data model is correct. If it isn’t, your DAX formulas aren’t going to work and your visualizations
In this tutorial, we’ll learn about staging queries using Power Query editor. This is a new concept that I’d like to discuss for us to have an understanding of when and where we can use this in the query editor. Staging queries can be used to configure and expose the data sources parameters to the dimension and fact table queries of the dataset. For Power BI datasets,
In today’s blog post, I’ll discuss some techniques on how to organize measures using a measure table in Power BI. The best way to organize your measures is to create measure groups or measure tables inside Power BI. It’s important to learn this technique because you’ll be dealing with hundreds of measures in your analysis.
In today’s blog post, I want to discuss how you can build additional data dimensions in Power BI. These dimensions can help you filter your data in different ways. On top of that, these dimensions can help you come up with intuitive visualizations later on. This is also the reason why you need to set