Urgent : SLA Time Difference b/w two dates except holidays

[Anonymous]

Dear Team,

i have start and end date need to get SLA between dates consider only working days  except public holidays dates.

[Anonymous]

Thanks a lot its working fine as per mentioned DAX function

[tamerj1 · Accepted solution]

Hi @Anonymous 
Here is a sample file with the solution https://we.tl/t-YHm9uduPCj

Time Took (SLA) = 
VAR StartDate = Data[Start date]
VAR EndDate = Data[End Date]
VAR T1 = CALENDAR ( StartDate, EndDate )
VAR T2 = FILTER ( T1, NOT ( WEEKDAY ( [Date], 2 ) IN { 6, 7 } ) )
VAR NumberOfDays = COUNTROWS ( T2 ) 
VAR TimeDifference = TIMEVALUE ( EndDate - StartDate )
VAR NumberOfHours = HOUR ( TimeDifference )
VAR NumberOfMinutes = MINUTE ( TimeDifference )
VAR NumberOfSeconds = SECOND ( TimeDifference )
RETURN
    NumberOfDays & " Day(s) " & NumberOfHours & " H " & NumberOfMinutes & " M " & NumberOfSeconds & " S"

[amitchandak]

@Anonymous , refer if this business hour blog can help

https://exceleratorbi.com.au/calculating-business-hours-using-dax/