Tag: Query Parameters

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

Changing File Location Using A Query Parameter In Power BI

Changing File Location Using A Query Parameter In Power BI

In this tutorial, you’ll be learning how to share a file with a person that’s not part of your company using a query parameter in Power BI. You may watch the full video of this tutorial at the bottom of this blog. The data used for this tutorial is a basic stock file containing clothes

Continue reading

Creating a Dynamic Date Query Table in Power BI: A Query Editor Tutorial

One question I got from the Enterprise DNA forum revolves around an addition to the date query table. This addition prevents you from having to manually filter data to the last date every time new data comes in. This can be helpful if you’re working on an ongoing report. You may watch the full video

Continue reading