Dynamic date table creation code

[BrianJ]

@Keith,

Here you go:

Extended Date Table (Power Query M function)

And here’s a great post from @Melissa on how to make the start and end dates dynamic, based on your fact table date ranges:

Creating a dynamic Start-/EndDate for the Date table

Hi everyone, To make it easier to find here are some Power Query techniques to make the Date table Startdate and/or Enddate dynamic. If you want to give that a try, go to Power Query, select New Source, Blank Query, open the Advanced Editor, paste in this Date table M code and Invoke that function. A new query will appear in the Queries pane with the name ‘Invoked Function’ in the formula bar of that query’s Source step you can distinguish the following elements. Date table function query na…

• Brian