Forum Discussion

logan_logan's avatar
logan_logan
Icon for Helper I rankHelper I
1 year ago
Solved

auto updated calendar

Hi , The following calendar invoked function is working properly. However everytime looks like i have to enter the start date and end date parameter.  As my dashboard will be weekly refresh so i need...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Power Query has functions for utcNow() and for date math  ( #duration).

     

    However!  Calendar data is immutable. There is no point in calculating it over and over again.  Use an external reference table with precomputed columns. No problem if that table covers the last 4 years and the next year too.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Power Query has functions for utcNow() and for date math  ( #duration).

 

However!  Calendar data is immutable. There is no point in calculating it over and over again.  Use an external reference table with precomputed columns. No problem if that table covers the last 4 years and the next year too.