Tag: Power BI Date Table

Creating A Date Table In Power BI The Fastest Way Possible

Enterprise DNA Power BI Video Tutorial Create a Detailed Date Table Fast

I’m going to show you a new approach in creating a date table in Power BI. I’ve done so many tutorials about creating date tables over the years, but the new method I’m using now is, by far, the most efficient way to do it. This is actually an approach created by Melissa, one of

Continue reading

Convert The Date Table Function Into A Table Query In Power BI

I’m going to show you how to turn an M code for a date table into a table query. I would consider the level of difficulty for this tutorial as intermediate because if you have any experience with M codes, it would be easy for you to follow along. If you don’t have any related

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

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