Working Days between to Dates and different countries

[joshua1990]

Hi experts!

I have a table that contains 2 date columns, 1 colunn with the article and 1 column with the country.

Now I would like to determine the working days between the dates.

The challenge is now that for each country different working days / public holidays exist.

1. How would you build the calendar table (structure) to make sure we can easily extract the public holidays / working days in the end?
2. Which function / approach would you use to determine the working days?

Thanks in advance!

[PwerQueryKees]

And you may have a look at Global Holiday Calendar API for National and Religious Holidays - Calendarific

They have a free plan as well....

[lbendlin · Accepted solution]

If you like you can read this blog entry

It's the weekend! Or is it? - Microsoft Fabric Community