Ohi Day and Clean Monday! Do you use Dynamic or Static Tables for Business Holidays on BI Reports (Greek version)? 🤔

In a recent BI project, I was thinking about dynamic holiday dates 📅 , who updates static tables, and what’s a safe approach for storage and maintenance 🫣 ? A static table from 2020 to 2050 might work, but it’s not always practical.

Creating something dynamic can take a bit more time ⏳ , but it provides a resilient solution 💪 for our clients. I finalised a Power Query solution for hashtag#Greek holidays that keeps hashtag#historical data minimal to 15 years while generating a hashtag#future range of 10 years ahead, sourced from the trusted Nager.Date API ⛓️‍💥 .

This ensures that business reports and hashtag#forecasts are hashtag#maintainable, forward-looking, and adaptable, and can be easily extended for other countries 🌐 .

👉 If your team could benefit, check out the code and documentation here: https://lnkd.in/ekD2BdyU