Tag: Date Table Power BI

Using The Offset Function In Extended Date Tables

Offset Function in Extended Date Tables

I’m going to show you how to use the offset function in Power BI. It’s one of the most dynamic tools you can use especially in your date tables. Once you master how to apply it in your time intelligence projects, you can get more in-depth insights that you won’t get using any other approach.

Continue reading

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 IsAfterToday for Power BI Time Intelligence Scenarios

Using The Extended Date Table - ISAFTERTODAY

I’m going to show you how to use IsAfterToday in extended date tables for Power BI time intelligence scenarios. When it comes to DAX functions and other tools, I assign them certain jobs or personas in my head so that I can easily remember what they do. For example, I see SWITCH as an air

Continue reading

The Importance Of Date Tables In Power BI

The Importance Of Date Tables In Power BI Enterprise DNA

When working on date tables, it’s important to know the essential techniques so you can set things up as quickly as possible. In this tutorial, I’ll go over some important tips that can help you. The date tables are important in Power BI because you’ll need them to reference dates inside your model. On top

Continue reading