Forum Discussion
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...
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.
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.