Billable Days in a Month

[bhmiller89]

I need to write a measure that indicates how many billable days are in a given month.  I figured out how to say if it is a weekday then yes, it is billable, but I can't figure out how to incorporate holidays. 

[Greg_Deckler · Accepted solution]

You probably need a holiday table with a Month column and then you could use something in another related table like:

COUNTROWS(RELATEDTABLE(HolidaysTable))