Tag: Query Parameters

Power BI Parameters Via Query Editor

Creating And Using Parameter

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

Continue reading

Function Query And Operators In The Query Editor

Function Query And Operators In The Query Editor

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

Continue reading

Using The M Function To Create An Extended Power BI Date Table

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

Continue reading

Organizing Your Queries: Power BI Query Editor Tutorial

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

Continue reading

Creating A Date Table In Power BI

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

Continue reading