topic Re: Date and time calculation for an SLA in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-and-time-calculation-for-an-SLA/m-p/3154925#M113135 <P><FONT face="tahoma,arial,helvetica,sans-serif">Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="535336" data-lia-user-login="LlintonWork" class="lia-mention lia-mention-user">LlintonWork</a>,</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">It seems like a common multiple data fields analysis requirement, I'd like to suggest you take a look at the Greg’s blog(he shared some common usage scenarios) ‘start date’, ‘end date’ part if helps:</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif"><A href="https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882" target="_self">Before You Post, Read This </A>&nbsp;</FONT><BR /><FONT face="tahoma,arial,helvetica,sans-serif">Regards,</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">Xiaoxin Sheng</FONT></P> Mon, 27 Mar 2023 01:58:48 GMT Anonymous 2023-03-27T01:58:48Z Date and time calculation for an SLA https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-and-time-calculation-for-an-SLA/m-p/3151099#M112862 <P>To be honest I am not even sure where to start. I have three measurements I need to add to a report. Each one is a date difference that also include start and stop times and no weekends. Any help would be appreciated.</P><P>&nbsp;</P><P>Measure One</P><P>PPM - M/F 07:00 to 19:00 (SNOW)</P><P>Case open date must fall between PPM or start clock for next day</P><P>Case must be assigned to Clarify if open within the PPM - Clarify Created date</P><P>Measure Two - Part Order</P><P>The part order must take place within the case open PPM</P><P>Case open date - SNOW = Case open date - Clarify</P><P>Part order date - Clarify</P><P>Measure Three - Part Ship</P><P>The PPM for the part order is M/F 07:00 to 14:00</P><P>The part needs to be ordered within the Part Order PPM</P><P>If the Part order is within the Part Order PPM the part need to show as shipped on that date</P><P>Part order (Clarify) 03/23/2023 13:30 = Part Ship date (Clarify) 03/23/2023</P><P>If the part order was completed outside of the part order PPM than the part must show shipped the next day.</P><P>Part order (Clarify) 03/23/2023 14:30 = Part Ship date (Clarify) 03/24/2023</P><DIV><TABLE border="1" cellspacing="0" cellpadding="0"><TBODY><TR><TD><P>INC_TICKET_NUMBER</P></TD><TD><P>F_CASE_ID</P></TD><TD><P>INC_INCIDENT_STATE</P></TD><TD><P>CUST_ENT_CODE</P></TD><TD><P>INC_CREATED_DATE SNOW</P></TD><TD><P>F_CASE_CREATED_DT Clarify</P></TD><TD><P>Measure One</P></TD><TD><P>ORDER_DATE, Clarify</P></TD><TD><P>Measure Two</P></TD><TD><P>GOOD_PART_SHIP_DATE Clarify</P></TD><TD><P>Measure three</P></TD></TR><TR><TD><P>INC42412071</P></TD><TD><P>C220330-17140679</P></TD><TD><P>Closed</P></TD><TD><P>AE WORKSTATION</P></TD><TD><P>3/30/2022 14:22</P></TD><TD><P>3/30/2022 14:28</P></TD><TD><P>Pass</P></TD><TD><P>3/30/2022 14:38</P></TD><TD><P>Pass</P></TD><TD><P>3/30/2022 14:43</P></TD><TD><P>Pass</P></TD></TR><TR><TD><P>INC44398734</P></TD><TD><P>C221024-17426468</P></TD><TD><P>Closed</P></TD><TD><P>AE WORKSTATION</P></TD><TD><P>10/24/2022 15:04</P></TD><TD><P>10/24/2022 15:17</P></TD><TD><P>Pass</P></TD><TD><P>10/24/2022 15:44</P></TD><TD><P>Pass</P></TD><TD><P>10/24/2022 16:08</P></TD><TD><P>Pass</P></TD></TR><TR><TD><P>INC44399012</P></TD><TD><P>C221024-17426497</P></TD><TD><P>Closed</P></TD><TD><P>AE WORKSTATION</P></TD><TD><P>10/24/2022 15:23</P></TD><TD><P>10/24/2022 15:25</P></TD><TD><P>Pass</P></TD><TD><P>10/24/2022 16:03</P></TD><TD><P>Pass</P></TD><TD><P>10/25/2022 11:20</P></TD><TD><P>Pass</P></TD></TR><TR><TD><P>INC44398860</P></TD><TD><P>C221024-17426481</P></TD><TD><P>Closed</P></TD><TD><P>AE WORKSTATION</P></TD><TD><P>10/24/2022 15:13</P></TD><TD><P>10/24/2022 15:21</P></TD><TD><P>Pass</P></TD><TD><P>10/24/2022 16:16</P></TD><TD><P>Pass</P></TD><TD><P>10/25/2022 11:23</P></TD><TD><P>Pass</P></TD></TR></TBODY></TABLE></DIV><P>&nbsp;</P><DIV>&nbsp;</DIV> Thu, 23 Mar 2023 22:00:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-and-time-calculation-for-an-SLA/m-p/3151099#M112862 LlintonWork 2023-03-23T22:00:10Z Re: Date and time calculation for an SLA https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-and-time-calculation-for-an-SLA/m-p/3154925#M113135 <P><FONT face="tahoma,arial,helvetica,sans-serif">Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="535336" data-lia-user-login="LlintonWork" class="lia-mention lia-mention-user">LlintonWork</a>,</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">It seems like a common multiple data fields analysis requirement, I'd like to suggest you take a look at the Greg’s blog(he shared some common usage scenarios) ‘start date’, ‘end date’ part if helps:</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif"><A href="https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882" target="_self">Before You Post, Read This </A>&nbsp;</FONT><BR /><FONT face="tahoma,arial,helvetica,sans-serif">Regards,</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">Xiaoxin Sheng</FONT></P> Mon, 27 Mar 2023 01:58:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Date-and-time-calculation-for-an-SLA/m-p/3154925#M113135 Anonymous 2023-03-27T01:58:48Z