Forum Discussion
Anonymous
5 years agoNot applicable
DAX SLA Calculation - Multiple Countries, different weekends and holidays
Hello experts, I have a complex scenario here, I need to calculate SLA using DAX for tickets related to different countries. I have 3 data tables- tickets data, weekly off, and Holidays. I can create/modify DATE dimension as required to acheive this.
I need to calculate "Business hours to close" considering all countries have working hours from 09:00 AM to 05:30 PM. Please refer to below screenshot for sample data.
DAX SLA Sample
If required, I can change the strcuture of Weekend table by moving DayName1 and DayName2 columns to rows instead of columns.
I am able to do in Excel with the help of NETWORKDAYS.INTL and other formulaes.
Any help/ suggestions would be appreciated. Thanks in advance!
No Replies