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,
This blog is a review of the Power BI Quick Measure feature. As the name describes, this feature is a way of creating measures quickly. There are some pros and cons to this, which I will discuss in detail. I’ll also give you an example on how to use this feature. DOWNLOAD FILES USED IN
In terms of business reporting, there’s nothing more versatile than Power BI. You can strategically extract key analysis and insights from your data using the different features of Power BI. However, Power BI has a lot of elements and features which can be overwhelming for beginners. That is why I want to give you a
This is a quick tutorial about how you can make your Power BI dashboard and app more presentable and business-themed using Power BI Online. Microsoft recently unveiled a series of updates for Power BI and it’s recommended you utilize these updates to maximize your data management. The dashboard is the key for better data insights,
One of the key concepts in DAX Context transition is one of the tougher concepts to know and understand well in the DAX language. Why do you even need to know it? Well, if you want to create calculations within calculated columns that reference columns from another table or if you want to run a
