Forum Discussion
bhmiller89
Helper V
Helper VBillable Days in a Month
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.
You probably need a holiday table with a Month column and then you could use something in another related table like:
COUNTROWS(RELATEDTABLE(HolidaysTable))
1 Reply
- Greg_Deckler
Community Champion
You probably need a holiday table with a Month column and then you could use something in another related table like:
COUNTROWS(RELATEDTABLE(HolidaysTable))