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
This tutorial will discuss the Function Query feature in the Query Editor. You’ll learn how to use and maximize function queries to get the results and data you desire. You’ll also understand how they work with operators to generate specific outcomes. Creating A Function Query Power Query allows users to define custom functions which map
This tutorial will cover about the most important Power BI dimension table in any model, the Date Table. You may watch the full video of this tutorial at the bottom of this blog. The best practice when designing a model is to check for date fields. If they are present, always include a date dimension
In this quick Power BI query editor tutorial, you’ll learn how to organize your queries to create intuitive models. You may watch the full video of this tutorial at the bottom of this blog. It’s important that your models are as intuitive as possible. Not only will this make it easier for you to work
The importance of creating a date table in Power BI is something that people often miss, especially in the Enterprise DNA forum. You may watch the full video of this tutorial at the bottom of this blog. Although it’s common to have a date column in your sales tables and transaction tables, that won’t be
