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

Anonymous's avatar
Anonymous
Not applicable
7 months ago

Hi ftm,

 

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to lbendlin and ToddChitt  for prompt and helpful responses.

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar