Forum Discussion

olimilo's avatar
olimilo
Post Prodigy
9 years ago

NETWORKDAYS with Holidays from different countries

Hi guys, this is a bit of a challenge for me and I'm hoping someone can help lead me in the right direction.   I have a Records table that I need to check for the # of working days from StartDate t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Here is an alternate method if you just want to count the public holidays:

 

Create a custom column in your Project Table and use this:

PubHol Count = Calculate(
	count('PubHol'[Date]),
	'PubHol'[Country] = [Country],
	'PubHol'[Date] >= [CompleteByStartDate],
	'PubHol'[Date] <= [CompleteByEndDate]
)

You will need to up date the table name, i've guessed it.

 

olimilo's avatar
olimilo
Post Prodigy
9 years ago

Okay, so this will be the first time I'll be working with a lot of dates, hope you bear with me here. Is this how the Date dimension table would look like?

 

 

Now I'm wondering how I can incorporate the holidays on each country to another table that I can create a relationship with this table.