Need a DAX formula to calculate SLA Ageing days & Ageing hours

[Shivkumar_1711]

Hi Team,

Need your Help to get the highlighted columns Ageing Days & Ageing Hours dax in Power BI.

Also need to exclude Weekends. 

Highlited in yellow column output needs to come in dax formula. Date and time need to consider from the created date and closed

CaseNumber	CreatedDate	ClosedDate	Ageing days	Ageing Hours
123	3/30/23 7:32 AM	3/31/23 9:19 AM	2	25:00:00
789	4/26/23 10:00 AM	4/27/23 10:00 AM	1	24:00:00
324	5/13/23 7:02 AM	5/15/23 7:20 AM	2	24:18:00
890	3/12/23 11:06 PM	3/13/23 11:14 AM	1	24:08:00

[v-shex-msft · Accepted solution]

HI @Shivkumar_1711,

For date range analysis requirements, you can refer the following blog start date end date parts if helps:
Before You Post, Read This: start, end date  

Regards,

Xiaoxin Sheng