I was helping a client this past week to calculate the total business hours between a start date/time and an end date/time, taking into account the working days, public holidays and non-working weekends, etc.
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
Leave a Reply