How to Make DateEnd parameter equal today

[Melissa]

Hi @JulieCarignan,

Welcome to the forum!

The DateTime.FixedLocalNow expression, will return a DateTime value set to the current date and time on the system. When combined with Date.From it is converted into a Date value. To illustrate:

Today = Date.From( DateTime.FixedLocalNow())

Some useful date related functions are highlighted here:

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…

I hope this is helpful