Tag: Date Table

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

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

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. The best practice when designing a model is to check for date fields. If they are present, always include a date dimension table. A Date Table includes all the attributes that you may want to slice, dice,

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. Although it’s common to have a date column in your sales tables and transaction tables, that won’t be enough. You’ll need a separate date table that you can link to all those other

Continue reading

Show Cumulative Totals Unaffected By Date Slicer Selection In Power BI

In this blog post, you’ll learn how to show data from specific time frames as filtered by a date slicer without affecting the overall Cumulative Totals. This is based on a query on the Enterprise DNA Members-Only Support Forum. For sure, you’ll find this quite useful when facing a scenario similar to the example that

Continue reading