Melissa
December 9, 2022, 10:29pm
205
Hi @jgriffit ,
I trust the reply provided by @DavieJoe was helpful. If you require further assistance please create a new thread. In the mean time these resources might be beneficial.
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…
1 Like