Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate time between 2 dates excluding weekends and holidays

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. :smileywink:

 

I have highlighted the 2 columns which I need:

 

 

 

Thanks very much,

 

Shahbaaz

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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