Forum Discussion
Updated Calendar Table to download?
Hi guys, Maybe a silly question, but I was using avisingh's PowerBi calendar table template for all my reports, but the year ended at 2020. Does anyone have a link to an updated calendar template...
If you are using the same file (it been updated over time) as I you can do it fairly easy:
Open Querry Editor
Right side under Applied Steps
3 step are called EndDate
Depeding on version you have you either:
- just change the date in the formula bar
or
- insert this formula instead of date (now the calender will "grow" over time 🙂
= Date.EndOfYear(DateTime.Date(DateTime.FixedLocalNow()))