https://community.fabric.microsoft.com/t5/Developer/Need-a-DAX-formula-to-calculate-SLA-Ageing-days-amp-Ageing-hours/m-p/3241630#M42724 <P>HI&nbsp;@Anonymous</a>,</P> <P>For date range analysis requirements, you can refer the following blog start date end date parts if helps:<BR /><A href="https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882#:~:text=You%20have%20a%20%E2%80%9Cstart%20date%E2%80%9D%20and%20an%20%E2%80%9Cend%20date%E2%80%9D" target="_self">Before You Post, Read This: start, end date </A>&nbsp;</P> <P>Regards,</P> <P>Xiaoxin Sheng</P> Thu, 18 May 2023 06:33:08 GMT Anonymous 2023-05-18T06:33:08Z https://community.fabric.microsoft.com/t5/Developer/Need-a-DAX-formula-to-calculate-SLA-Ageing-days-amp-Ageing-hours/m-p/3237456#M42683 <P>Hi Team,</P><P>&nbsp;</P><P>Need your Help to get the highlighted columns Ageing Days &amp; Ageing Hours dax in Power BI.</P><P>Also need to exclude Weekends.&nbsp;</P><P>Highlited in yellow column output needs to come in dax formula. Date and time need to consider from the created date and closed</P><TABLE><TBODY><TR><TD>CaseNumber</TD><TD>CreatedDate</TD><TD>ClosedDate</TD><TD><FONT color="#FFFF00">Ageing days</FONT></TD><TD><FONT color="#FFFF00">Ageing Hours</FONT></TD></TR><TR><TD>123</TD><TD>3/30/23 7:32 AM</TD><TD>3/31/23 9:19 AM</TD><TD>2</TD><TD>25:00:00</TD></TR><TR><TD>789</TD><TD>4/26/23 10:00 AM</TD><TD>4/27/23 10:00 AM</TD><TD>1</TD><TD>24:00:00</TD></TR><TR><TD>324</TD><TD>5/13/23 7:02 AM</TD><TD>5/15/23 7:20 AM</TD><TD>2</TD><TD>24:18:00</TD></TR><TR><TD>890</TD><TD>3/12/23 11:06 PM</TD><TD>3/13/23 11:14 AM</TD><TD>1</TD><TD>24:08:00</TD></TR></TBODY></TABLE><P>&nbsp;</P> Tue, 16 May 2023 09:54:24 GMT https://community.fabric.microsoft.com/t5/Developer/Need-a-DAX-formula-to-calculate-SLA-Ageing-days-amp-Ageing-hours/m-p/3237456#M42683 Anonymous 2023-05-16T09:54:24Z https://community.fabric.microsoft.com/t5/Developer/Need-a-DAX-formula-to-calculate-SLA-Ageing-days-amp-Ageing-hours/m-p/3241630#M42724 <P>HI&nbsp;@Anonymous</a>,</P> <P>For date range analysis requirements, you can refer the following blog start date end date parts if helps:<BR /><A href="https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882#:~:text=You%20have%20a%20%E2%80%9Cstart%20date%E2%80%9D%20and%20an%20%E2%80%9Cend%20date%E2%80%9D" target="_self">Before You Post, Read This: start, end date </A>&nbsp;</P> <P>Regards,</P> <P>Xiaoxin Sheng</P> Thu, 18 May 2023 06:33:08 GMT https://community.fabric.microsoft.com/t5/Developer/Need-a-DAX-formula-to-calculate-SLA-Ageing-days-amp-Ageing-hours/m-p/3241630#M42724 Anonymous 2023-05-18T06:33:08Z