BrianJ
February 19, 2021, 5:19pm
4
@LucaB72 ,
In addition to the video @Harsh recommended, there is also an epic post by @Melissa on this topic that addresses all aspects of this question in a really clear way:
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