CY Weekdays Remaining

Description:

- To calculate the number of weekdays remaining CY.

- Built on top of CY Days Remaining, filtering out weekends and holidays.

- Used in Max Risk calculator.

Code:

CY Weekdays Remaining = CALCULATE(COUNT('Calendar'[Date]), 'Calendar'[Fiscal Year] = 2021,

'Calendar'[Holiday.Holidays/No School] <> 1, 'Calendar'[Date] > TODAY(), 'Calendar'[Day Name] <> "Saturday", 'Calendar'[Day Name] <> "Sunday")