Conditional Calculation for Date Difference

[kag]

Hi All,

I have a set of data that looks like the below

Start Date	End Date	Status	TAT	SLA [2 Days]
03-04-2022  5:40AM	05-04-2022  3:40AM	Success	1 Day 22 hours	Completed
03-04-2022  5:40AM		Customer		1 Day 9 Hours
03-04-2022  5:40AM		Reviewer		1 Day 3 Hours

I am trying to calculate SLA and TAT here.

TAT is the Duration of days between End date and Start date excluding weekends.

The request should be completed within 2 days of Start Date excluding weekends and the SLA calculation should pause whenever the status says "Customer" and resume when the Status becomes "Reviewer".

Can someone help me with this please? I am very new to Power BI, thanks in advance!

[v-stephen-msft]

Hi @kag ,

For the TAT column, you could refer to this post:

Solved: Re: Difference of dates in days by excluding weeke... - Microsoft Power BI Community

For the SLA [2 Days] column, I still wonder how this number of days and hours is calculated, "completed" is because the Status column is "Success", right?

Best Regards,

Stephen Tao

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