Forum Discussion

Regular Visitor

5 years ago

How to Calculate TAT

Hi Leads, How to calculate the TAT between received date and closed date excluding the weekends and holidays. Please help me on this.

Super User

5 years ago

A new column like

Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Table[received Date],Table[closed Date]),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))

Refer

How to calculate Business Days/ Workdays, with or without date table: https://youtu.be/Qv4wT8_P-AA