Forum Discussion
Post ProdigyNETWORKDAYS with Holidays from different countries
Its really going to come down to how you write your measures. For example you might have a measure that needs to count the number of holidays in your holiday table. This measure might be part of a Matrix, thus there is already a date range and country filter. Thus when the measure is run, it can only see "Dates" in your range and the country name.
On the other way around. If you were using a measure to "Count the number of countries on holiday", you might be doing this via a filter that uses a single date. By doing this, the measure will only see that day and return the count.
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.
olimiloOkay, 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.