Tag: Power BI Power Query

Creating Values For Each Date Using Power Query Formula

In this tutorial, you’ll learn how to create values for each day using Power Query formula in Power BI. Creating values for dates is an important technique to learn in Power BI. It can give you the data you want to see throughout the days in your model. This technique also covers the gaps between

Continue reading

Setting Up A Dynamic StartDate And EndDate For Power Query Date Tables

I’ll show you how to set up dynamic start and end dates when you’re using power query date tables. If you’ve been following this series on different Time Intelligence subjects, you already know how to create a date table using power query functions. You might have also read about how to change the end date

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

Change Date Formats Using The Power Query Editor

In this tutorial, we’re going to go over a quick solution on how to change date formats using the power query editor in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This is from a recent Enterprise DNA member-only event which featured the production data of

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