Forum Discussion

ftm's avatar
ftm
Frequent Visitor
7 months ago
Solved

Dynamic Public Holidays Table (Power Query / Power BI)

Hello everyone,   With future reuse in mind, I’m sharing a dynamic Power Query (M) solution that retrieves Greek public holidays (country can be changed) from the trusted Nager.Date public API.   ...
Interesting Links
  • lbendlin's avatar
    lbendlin
    6 months ago

    Dates are immutable. There is absolutely no need to do this in Power Query or DAX.  Use an externally maintained reference table.

  • ToddChitt's avatar
    ToddChitt
    6 months ago

    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!)

ToddChitt's avatar
ToddChitt
Super User
6 months ago

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!)