Calculate time between 2 dates excluding weekends and holidays

[Anonymous]

Hi,

I am trying to calculate how long it takes for incoming tickets to be resolved. I posted earlier a message about this but the data colums were old so I am trying to get a solution for my problem. Since I just started using Power BI, please give a solution in baby steps.

I have highlighted the 2 columns which I need:

Thanks very much,

Shahbaaz

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

I'd like to suggest you to take a look at following link about calculate working hours between two datetime fields:

Calculating Working hours

You can use except function to exclude holiday date from variable filtered.

Regards,

Xiaoxin Sheng

[Anonymous]

I didnt mention it in my message but it need to exlude weekend and holidays aswell