Expected hours per day

lbendlin , thanks for your concern about this case, I have an addition to make to the content.

Hi  metcala ,

If by weekdays you mean Monday to Friday, you can add the following filter to the formula:

NOT(WEEKDAY(MAX('Table'[Date]),2)) in {6,7}

If by weekdays you mean not only Monday to Friday but also the rest of the holidays, you can first use Enter data to create a table to collect the holiday information and add the following filter to the formula:

NOT(WEEKDAY(MAX('Table'[Date]),2)) in {6,7} && NOT(MAX('Table'[Date])) in SELECTCOLUMNS('Holidays_Table',"date",[Holidays])

If it doesn't meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.