Forum Discussion
Dynamic Public Holidays Table (Power Query / Power BI)
Dates are immutable. There is absolutely no need to do this in Power Query or DAX. Use an externally maintained reference table.
Totally agree with lbendlin . 30 years of dates is less than 11,000 records. 30 years of holidays, (at least ones you need to track, like TIME OFF days) would be in the hundreds.
Stick it in an external table and move on.
(I have seen code that that was so designed as to allow additional MONTHS to be added to a calendar. JUST IN CASE!)
Good points. I absolutely agree that a static reference table is the most appropriate approach.
The idea here was mainly to demonstrate a reusable Power Query pattern that could potentially be adapted for larger or more frequently changing datasets.
Out of curiosity, in your experience, what kinds of datasets do you think this type of approach would be most appropriate for?