topic Re: How can I calculate elapsed working time within a date filter in Power BI? in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4778078#M183000 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1309863" data-lia-user-login="brisacisnerosc" class="lia-mention lia-mention-user">brisacisnerosc</a>&nbsp;,</P> <P>May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.</P> <P>Thank you.</P> <P><LI-WRAPPER></LI-WRAPPER></P> Mon, 28 Jul 2025 07:19:56 GMT v-venuppu 2025-07-28T07:19:56Z How can I calculate elapsed working time within a date filter in Power BI? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4764099#M182481 <P>Hi everyone,</P><P>I’m trying to calculate the elapsed duration of activities within a selected date range in Power BI. I have two columns:</P><UL><LI><P>Start Time (DateTime)</P></LI><LI><P>End Time (DateTime), which can be blank if the activity is still ongoing.</P></LI></UL><P>I want to create a <STRONG>measure</STRONG> that calculates the working hours <STRONG>only within the range defined by my date filter</STRONG>. For example, if an activity starts on <STRONG>July 8 at 2:00 PM</STRONG> and ends on <STRONG>July 15 at 9:00 AM</STRONG>, but my report is filtered from <STRONG>July 9 to July 11</STRONG>, I only want to count the working hours <STRONG>between those two dates</STRONG>.</P><P>The calculation should follow these rules:</P><UL><LI><P>Only count time between <STRONG>7:00 AM and 4:30 PM</STRONG> (working hours).</P></LI><LI><P>Subtract <STRONG>1 hour for lunch (12:00 PM to 1:00 PM)</STRONG> if the activity overlaps that time.</P></LI><LI><P><STRONG>Exclude weekends</STRONG> (Saturday and Sunday).</P></LI></UL><P><STRONG>My extra question is:</STRONG><BR />I’m not sure <STRONG>which column to use for the date filter</STRONG> so that the measure works correctly. Should it be based on Start Time, End Time, or maybe a disconnected calendar table? I want the measure to respond accurately to the date range I select on my report.</P><P>Any help or best practices would be greatly appreciated!</P><P>Thanks in advance!</P> Tue, 15 Jul 2025 17:42:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4764099#M182481 brisacisnerosc 2025-07-15T17:42:55Z Re: How can I calculate elapsed working time within a date filter in Power BI? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4764211#M182494 <P>Please provide a few rows of the activities table with start and end date/time</P><P>&nbsp;</P><P>On your question, I am not sure if you are asking what relationship to estabilish between a calendar table and the activities table (model question) or if you are asking how to filter data via DAX (measure question)</P><P>&nbsp;</P><P>If this helped, please consider giving kudos and mark as a solution</P><P><STRONG><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="273" data-lia-user-login="me" class="lia-mention lia-mention-user">me</a> in replies or I'll lose your thread</STRONG></P><P>consider voting <A href="https://community.fabric.microsoft.com/t5/Fabric-Ideas/Power-BI-Filter-Pane-as-an-icon-on-the-right-side-bar-in-on/idi-p/4728588" target="_blank">this Power BI idea</A></P><P><STRONG>Francesco Bergamaschi</STRONG></P><P>MBA, M.Eng, M.Econ, Professor of BI</P> Tue, 15 Jul 2025 19:15:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4764211#M182494 FBergamaschi 2025-07-15T19:15:44Z Re: How can I calculate elapsed working time within a date filter in Power BI? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4764242#M182496 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1309863" data-lia-user-login="brisacisnerosc" class="lia-mention lia-mention-user">brisacisnerosc</a>&nbsp;pls share the sample datasets</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 15 Jul 2025 19:39:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4764242#M182496 techies 2025-07-15T19:39:45Z Re: How can I calculate elapsed working time within a date filter in Power BI? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4764273#M182498 <P>Regarding your question — I think it's a bit of both:</P><UL><LI><P><STRONG>From a data model perspective</STRONG>, I’m wondering how best to structure the relationship between a calendar table and the activities table, especially since activities can span multiple days.</P></LI><LI><P><STRONG>From a DAX perspective</STRONG>, I’d like to know how to calculate working hours correctly within the selected date range in the report.</P></LI><LI><P>The file includes the columns 'Start Time' and 'End Time', with a few sample rows showing ongoing and completed activities.</P></LI><LI><TABLE><TBODY><TR><TD>ID ACTIVITY</TD><TD>START TIME</TD><TD>END TIME</TD></TR><TR><TD>fd040cad</TD><TD>09/07/2025 14:39</TD><TD>09/07/2025 15:56</TD></TR><TR><TD>1cd1ba41</TD><TD>09/07/2025 15:40</TD><TD>11/07/2025 07:56</TD></TR><TR><TD>4adbaf85</TD><TD>10/07/2025 07:13</TD><TD>10/07/2025 09:29</TD></TR><TR><TD>a1fc6ced</TD><TD>10/07/2025 07:33</TD><TD>10/07/2025 10:30</TD></TR><TR><TD>7adb0344</TD><TD>10/07/2025 07:34</TD><TD>10/07/2025 11:23</TD></TR><TR><TD>f03e7d71</TD><TD>10/07/2025 07:45</TD><TD>10/07/2025 07:46</TD></TR><TR><TD>dc60edb6</TD><TD>10/07/2025 07:46</TD><TD>10/07/2025 07:46</TD></TR><TR><TD>f3f0f163</TD><TD>10/07/2025 08:30</TD><TD>10/07/2025 10:41</TD></TR><TR><TD>1d294d3b</TD><TD>10/07/2025 09:29</TD><TD>10/07/2025 11:05</TD></TR><TR><TD>c16541a9</TD><TD>10/07/2025 10:30</TD><TD>11/07/2025 07:22</TD></TR><TR><TD>f3642705</TD><TD>10/07/2025 10:41</TD><TD>10/07/2025 13:26</TD></TR><TR><TD>0e1b9630</TD><TD>10/07/2025 11:05</TD><TD>10/07/2025 11:18</TD></TR><TR><TD>e5e621db</TD><TD>10/07/2025 11:13</TD><TD>10/07/2025 16:22</TD></TR><TR><TD>04acf5b0</TD><TD>10/07/2025 11:18</TD><TD>10/07/2025 11:43</TD></TR><TR><TD>130eaf91</TD><TD>10/07/2025 11:43</TD><TD>10/07/2025 13:23</TD></TR><TR><TD>91e6c8b0</TD><TD>10/07/2025 13:23</TD><TD>10/07/2025 14:06</TD></TR><TR><TD>de11d240</TD><TD>10/07/2025 13:26</TD><TD>11/07/2025 09:05</TD></TR><TR><TD>afc0b5aa</TD><TD>10/07/2025 14:53</TD><TD>11/07/2025 15:01</TD></TR><TR><TD>d82163de</TD><TD>11/07/2025 07:26</TD><TD>11/07/2025 08:57</TD></TR><TR><TD>23b07831</TD><TD>11/07/2025 08:02</TD><TD>14/07/2025 10:21</TD></TR><TR><TD>f55e0aa3</TD><TD>11/07/2025 07:30</TD><TD>11/07/2025 09:00</TD></TR><TR><TD>1b57370b</TD><TD>11/07/2025 09:19</TD><TD>11/07/2025 10:40</TD></TR><TR><TD>6c2633ac</TD><TD>11/07/2025 09:46</TD><TD>14/07/2025 10:03</TD></TR><TR><TD>0e40d102</TD><TD>11/07/2025 10:19</TD><TD>11/07/2025 16:03</TD></TR><TR><TD>aaac0df4</TD><TD>11/07/2025 10:40</TD><TD>11/07/2025 16:22</TD></TR><TR><TD>00f6501d</TD><TD>11/07/2025 14:35</TD><TD>14/07/2025 10:04</TD></TR><TR><TD>77b65cc4</TD><TD>14/07/2025 07:40</TD><TD>14/07/2025 07:47</TD></TR><TR><TD>6bba6576</TD><TD>14/07/2025 07:51</TD><TD>15/07/2025 07:12</TD></TR><TR><TD>ec2c1c95</TD><TD>14/07/2025 07:57</TD><TD>14/07/2025 16:25</TD></TR><TR><TD>966994d9</TD><TD>14/07/2025 08:06</TD><TD>&nbsp;</TD></TR><TR><TD>61767af7</TD><TD>14/07/2025 07:00</TD><TD>14/07/2025 08:37</TD></TR><TR><TD>0b523fa8</TD><TD>14/07/2025 08:40</TD><TD>14/07/2025 14:25</TD></TR><TR><TD>4dab9034</TD><TD>14/07/2025 08:53</TD><TD>14/07/2025 09:25</TD></TR><TR><TD>e4a87ec9</TD><TD>14/07/2025 10:25</TD><TD>14/07/2025 16:04</TD></TR><TR><TD>232dfba1</TD><TD>14/07/2025 10:56</TD><TD>14/07/2025 16:04</TD></TR><TR><TD>c3d5af56</TD><TD>14/07/2025 13:27</TD><TD>14/07/2025 16:27</TD></TR><TR><TD>e8d815d1</TD><TD>14/07/2025 13:55</TD><TD>15/07/2025 07:30</TD></TR><TR><TD>b808b452</TD><TD>14/07/2025 14:14</TD><TD>14/07/2025 16:29</TD></TR><TR><TD>f3c7efae</TD><TD>14/07/2025 14:54</TD><TD>15/07/2025 07:04</TD></TR><TR><TD>97186694</TD><TD>14/07/2025 21:27</TD><TD>&nbsp;</TD></TR><TR><TD>c4842be1</TD><TD>15/07/2025 07:01</TD><TD>&nbsp;</TD></TR><TR><TD>f899cc09</TD><TD>15/07/2025 07:04</TD><TD>15/07/2025 10:30</TD></TR><TR><TD>096ff292</TD><TD>15/07/2025 07:05</TD><TD>&nbsp;</TD></TR><TR><TD>47585dc1</TD><TD>15/07/2025 07:06</TD><TD>&nbsp;</TD></TR><TR><TD>d62fd73c</TD><TD>15/07/2025 07:07</TD><TD>&nbsp;</TD></TR><TR><TD>6338c4b0</TD><TD>15/07/2025 07:08</TD><TD>&nbsp;</TD></TR><TR><TD>a60d4376</TD><TD>15/07/2025 07:13</TD><TD>&nbsp;</TD></TR><TR><TD>e5b0d159</TD><TD>15/07/2025 07:30</TD><TD>&nbsp;</TD></TR><TR><TD>b174bacc</TD><TD>15/07/2025 08:07</TD><TD>&nbsp;</TD></TR></TBODY></TABLE></LI></UL><P>Thanks again for the support!</P><P>— Brisa</P> Tue, 15 Jul 2025 20:03:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4764273#M182498 brisacisnerosc 2025-07-15T20:03:25Z Re: How can I calculate elapsed working time within a date filter in Power BI? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4764276#M182499 <P>&nbsp;</P><TABLE><TBODY><TR><TD>ID ACTIVITY</TD><TD>START TIME</TD><TD>END TIME</TD></TR><TR><TD>4e0c48e4</TD><TD>01/07/2025 07:21</TD><TD>02/07/2025 09:05</TD></TR><TR><TD>24069dc1</TD><TD>01/07/2025 07:22</TD><TD>01/07/2025 16:17</TD></TR><TR><TD>792309eb</TD><TD>01/07/2025 07:28</TD><TD>01/07/2025 16:14</TD></TR><TR><TD>1ac89f1f</TD><TD>01/07/2025 07:30</TD><TD>01/07/2025 16:10</TD></TR><TR><TD>7d6b3aaa</TD><TD>01/07/2025 07:32</TD><TD>01/07/2025 14:29</TD></TR><TR><TD>8f540261</TD><TD>01/07/2025 07:50</TD><TD>02/07/2025 09:19</TD></TR><TR><TD>95b767f6</TD><TD>01/07/2025 10:06</TD><TD>02/07/2025 09:47</TD></TR><TR><TD>712a5dbf</TD><TD>01/07/2025 14:29</TD><TD>01/07/2025 16:18</TD></TR><TR><TD>ecd6a751</TD><TD>01/07/2025 16:18</TD><TD>02/07/2025 08:36</TD></TR><TR><TD>109d5abd</TD><TD>02/07/2025 07:02</TD><TD>02/07/2025 08:27</TD></TR><TR><TD>670de4f5</TD><TD>02/07/2025 07:02</TD><TD>02/07/2025 08:37</TD></TR><TR><TD>d70f066a</TD><TD>02/07/2025 07:40</TD><TD>02/07/2025 16:19</TD></TR><TR><TD>15b59329</TD><TD>02/07/2025 09:14</TD><TD>02/07/2025 09:18</TD></TR><TR><TD>a4cafcf7</TD><TD>02/07/2025 09:48</TD><TD>02/07/2025 11:01</TD></TR><TR><TD>bbaa150e</TD><TD>02/07/2025 10:06</TD><TD>08/07/2025 09:16</TD></TR><TR><TD>bfe89f0c</TD><TD>02/07/2025 10:08</TD><TD>02/07/2025 10:18</TD></TR><TR><TD>bd8880f6</TD><TD>02/07/2025 11:02</TD><TD>02/07/2025 13:03</TD></TR><TR><TD>5abd6429</TD><TD>02/07/2025 13:05</TD><TD>02/07/2025 16:13</TD></TR><TR><TD>3b524ce2</TD><TD>02/07/2025 13:10</TD><TD>02/07/2025 13:19</TD></TR><TR><TD>dd6cdf54</TD><TD>03/07/2025 07:04</TD><TD>03/07/2025 16:15</TD></TR><TR><TD>9c3fdac7</TD><TD>03/07/2025 07:05</TD><TD>03/07/2025 16:16</TD></TR><TR><TD>0169c677</TD><TD>03/07/2025 07:17</TD><TD>03/07/2025 16:18</TD></TR><TR><TD>27b60207</TD><TD>03/07/2025 07:19</TD><TD>04/07/2025 16:00</TD></TR><TR><TD>5739bbcb</TD><TD>03/07/2025 07:20</TD><TD>08/07/2025 09:15</TD></TR><TR><TD>1fff1c9b</TD><TD>03/07/2025 07:23</TD><TD>03/07/2025 16:14</TD></TR><TR><TD>515a1299</TD><TD>03/07/2025 08:05</TD><TD>03/07/2025 16:14</TD></TR><TR><TD>f92da840</TD><TD>03/07/2025 08:07</TD><TD>07/07/2025 07:37</TD></TR><TR><TD>8008d046</TD><TD>03/07/2025 14:08</TD><TD>04/07/2025 09:16</TD></TR><TR><TD>3f345403</TD><TD>04/07/2025 07:49</TD><TD>04/07/2025 16:22</TD></TR><TR><TD>934444f3</TD><TD>04/07/2025 09:42</TD><TD>04/07/2025 09:43</TD></TR><TR><TD>aabaa29f</TD><TD>04/07/2025 09:52</TD><TD>04/07/2025 11:02</TD></TR><TR><TD>a95e6d93</TD><TD>04/07/2025 10:33</TD><TD>04/07/2025 16:15</TD></TR><TR><TD>10b08ee0</TD><TD>07/07/2025 07:16</TD><TD>07/07/2025 08:41</TD></TR><TR><TD>6ec4387c</TD><TD>07/07/2025 08:09</TD><TD>07/07/2025 13:07</TD></TR><TR><TD>dbc59872</TD><TD>07/07/2025 08:33</TD><TD>08/07/2025 07:59</TD></TR><TR><TD>c1e1ea2f</TD><TD>07/07/2025 08:41</TD><TD>07/07/2025 09:00</TD></TR><TR><TD>f2518d62</TD><TD>07/07/2025 09:43</TD><TD>08/07/2025 09:29</TD></TR><TR><TD>7615c22f</TD><TD>07/07/2025 13:07</TD><TD>07/07/2025 14:44</TD></TR><TR><TD>07b6850a</TD><TD>07/07/2025 14:44</TD><TD>08/07/2025 07:12</TD></TR><TR><TD>e83e78f6</TD><TD>07/07/2025 15:54</TD><TD>07/07/2025 16:11</TD></TR><TR><TD>ba7b18ca</TD><TD>08/07/2025 07:04</TD><TD>08/07/2025 08:53</TD></TR><TR><TD>257ecfd4</TD><TD>08/07/2025 07:10</TD><TD>08/07/2025 07:11</TD></TR><TR><TD>6c6c86b2</TD><TD>08/07/2025 07:10</TD><TD>08/07/2025 09:18</TD></TR><TR><TD>e4bda079</TD><TD>08/07/2025 07:12</TD><TD>08/07/2025 10:02</TD></TR><TR><TD>d023633d</TD><TD>08/07/2025 07:59</TD><TD>08/07/2025 14:44</TD></TR><TR><TD>7529231a</TD><TD>08/07/2025 09:30</TD><TD>08/07/2025 16:29</TD></TR><TR><TD>d78511db</TD><TD>08/07/2025 10:02</TD><TD>08/07/2025 16:01</TD></TR><TR><TD>5500fa35</TD><TD>08/07/2025 13:53</TD><TD>10/07/2025 14:53</TD></TR><TR><TD>b591a940</TD><TD>08/07/2025 14:44</TD><TD>09/07/2025 10:15</TD></TR><TR><TD>cb07ac88</TD><TD>09/07/2025 07:09</TD><TD>09/07/2025 07:58</TD></TR><TR><TD>dd7958c8</TD><TD>09/07/2025 07:09</TD><TD>09/07/2025 08:48</TD></TR><TR><TD>6febf55b</TD><TD>09/07/2025 07:11</TD><TD>09/07/2025 16:20</TD></TR><TR><TD>51a5c4ac</TD><TD>09/07/2025 07:58</TD><TD>09/07/2025 08:18</TD></TR><TR><TD>404a5c63</TD><TD>09/07/2025 08:18</TD><TD>09/07/2025 08:34</TD></TR><TR><TD>c4818946</TD><TD>09/07/2025 08:34</TD><TD>09/07/2025 09:44</TD></TR><TR><TD>c6f50ea2</TD><TD>09/07/2025 08:48</TD><TD>09/07/2025 14:39</TD></TR><TR><TD>de23c405</TD><TD>09/07/2025 10:21</TD><TD>10/07/2025 10:35</TD></TR><TR><TD>d028d2c8</TD><TD>09/07/2025 10:41</TD><TD>09/07/2025 11:08</TD></TR><TR><TD>0006d66a</TD><TD>09/07/2025 10:47</TD><TD>09/07/2025 10:54</TD></TR><TR><TD>2e8bcd96</TD><TD>09/07/2025 10:54</TD><TD>09/07/2025 16:20</TD></TR><TR><TD>a97055af</TD><TD>09/07/2025 11:10</TD><TD>09/07/2025 13:09</TD></TR><TR><TD>8543d598</TD><TD>09/07/2025 13:11</TD><TD>09/07/2025 15:28</TD></TR><TR><TD>fd040cad</TD><TD>09/07/2025 14:39</TD><TD>09/07/2025 15:56</TD></TR><TR><TD>1cd1ba41</TD><TD>09/07/2025 15:40</TD><TD>11/07/2025 07:56</TD></TR><TR><TD>4adbaf85</TD><TD>10/07/2025 07:13</TD><TD>10/07/2025 09:29</TD></TR><TR><TD>a1fc6ced</TD><TD>10/07/2025 07:33</TD><TD>10/07/2025 10:30</TD></TR><TR><TD>7adb0344</TD><TD>10/07/2025 07:34</TD><TD>10/07/2025 11:23</TD></TR><TR><TD>f03e7d71</TD><TD>10/07/2025 07:45</TD><TD>10/07/2025 07:46</TD></TR><TR><TD>dc60edb6</TD><TD>10/07/2025 07:46</TD><TD>10/07/2025 07:46</TD></TR><TR><TD>f3f0f163</TD><TD>10/07/2025 08:30</TD><TD>10/07/2025 10:41</TD></TR><TR><TD>1d294d3b</TD><TD>10/07/2025 09:29</TD><TD>10/07/2025 11:05</TD></TR><TR><TD>c16541a9</TD><TD>10/07/2025 10:30</TD><TD>11/07/2025 07:22</TD></TR><TR><TD>f3642705</TD><TD>10/07/2025 10:41</TD><TD>10/07/2025 13:26</TD></TR><TR><TD>0e1b9630</TD><TD>10/07/2025 11:05</TD><TD>10/07/2025 11:18</TD></TR><TR><TD>e5e621db</TD><TD>10/07/2025 11:13</TD><TD>10/07/2025 16:22</TD></TR><TR><TD>04acf5b0</TD><TD>10/07/2025 11:18</TD><TD>10/07/2025 11:43</TD></TR><TR><TD>130eaf91</TD><TD>10/07/2025 11:43</TD><TD>10/07/2025 13:23</TD></TR><TR><TD>91e6c8b0</TD><TD>10/07/2025 13:23</TD><TD>10/07/2025 14:06</TD></TR><TR><TD>de11d240</TD><TD>10/07/2025 13:26</TD><TD>11/07/2025 09:05</TD></TR><TR><TD>afc0b5aa</TD><TD>10/07/2025 14:53</TD><TD>11/07/2025 15:01</TD></TR><TR><TD>d82163de</TD><TD>11/07/2025 07:26</TD><TD>11/07/2025 08:57</TD></TR><TR><TD>23b07831</TD><TD>11/07/2025 08:02</TD><TD>14/07/2025 10:21</TD></TR><TR><TD>f55e0aa3</TD><TD>11/07/2025 07:30</TD><TD>11/07/2025 09:00</TD></TR><TR><TD>1b57370b</TD><TD>11/07/2025 09:19</TD><TD>11/07/2025 10:40</TD></TR><TR><TD>6c2633ac</TD><TD>11/07/2025 09:46</TD><TD>14/07/2025 10:03</TD></TR><TR><TD>0e40d102</TD><TD>11/07/2025 10:19</TD><TD>11/07/2025 16:03</TD></TR><TR><TD>aaac0df4</TD><TD>11/07/2025 10:40</TD><TD>11/07/2025 16:22</TD></TR><TR><TD>00f6501d</TD><TD>11/07/2025 14:35</TD><TD>14/07/2025 10:04</TD></TR><TR><TD>77b65cc4</TD><TD>14/07/2025 07:40</TD><TD>14/07/2025 07:47</TD></TR><TR><TD>6bba6576</TD><TD>14/07/2025 07:51</TD><TD>15/07/2025 07:12</TD></TR><TR><TD>ec2c1c95</TD><TD>14/07/2025 07:57</TD><TD>14/07/2025 16:25</TD></TR><TR><TD>966994d9</TD><TD>14/07/2025 08:06</TD><TD>&nbsp;</TD></TR><TR><TD>61767af7</TD><TD>14/07/2025 07:00</TD><TD>14/07/2025 08:37</TD></TR><TR><TD>0b523fa8</TD><TD>14/07/2025 08:40</TD><TD>14/07/2025 14:25</TD></TR><TR><TD>4dab9034</TD><TD>14/07/2025 08:53</TD><TD>14/07/2025 09:25</TD></TR><TR><TD>e4a87ec9</TD><TD>14/07/2025 10:25</TD><TD>14/07/2025 16:04</TD></TR><TR><TD>232dfba1</TD><TD>14/07/2025 10:56</TD><TD>14/07/2025 16:04</TD></TR><TR><TD>c3d5af56</TD><TD>14/07/2025 13:27</TD><TD>14/07/2025 16:27</TD></TR><TR><TD>e8d815d1</TD><TD>14/07/2025 13:55</TD><TD>15/07/2025 07:30</TD></TR><TR><TD>b808b452</TD><TD>14/07/2025 14:14</TD><TD>14/07/2025 16:29</TD></TR><TR><TD>f3c7efae</TD><TD>14/07/2025 14:54</TD><TD>15/07/2025 07:04</TD></TR><TR><TD>97186694</TD><TD>14/07/2025 21:27</TD><TD>&nbsp;</TD></TR><TR><TD>c4842be1</TD><TD>15/07/2025 07:01</TD><TD>&nbsp;</TD></TR><TR><TD>f899cc09</TD><TD>15/07/2025 07:04</TD><TD>15/07/2025 10:30</TD></TR><TR><TD>096ff292</TD><TD>15/07/2025 07:05</TD><TD>&nbsp;</TD></TR><TR><TD>47585dc1</TD><TD>15/07/2025 07:06</TD><TD>&nbsp;</TD></TR><TR><TD>d62fd73c</TD><TD>15/07/2025 07:07</TD><TD>&nbsp;</TD></TR><TR><TD>6338c4b0</TD><TD>15/07/2025 07:08</TD><TD>15/07/2025 13:05</TD></TR><TR><TD>a60d4376</TD><TD>15/07/2025 07:13</TD><TD>&nbsp;</TD></TR><TR><TD>e5b0d159</TD><TD>15/07/2025 07:30</TD><TD>&nbsp;</TD></TR><TR><TD>b174bacc</TD><TD>15/07/2025 08:07</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Tue, 15 Jul 2025 20:07:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4764276#M182499 brisacisnerosc 2025-07-15T20:07:33Z Re: How can I calculate elapsed working time within a date filter in Power BI? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4764315#M182504 <P>Regarding your question — I think it's a bit of both:</P><UL><LI><P><STRONG>From a data model perspective</STRONG>, I’m wondering how best to structure the relationship between a calendar table and the activities table, especially since activities can span multiple days.</P></LI><LI><P><STRONG>From a DAX perspective</STRONG>, I’d like to know how to calculate working hours correctly within the selected date range in the report.</P></LI></UL><P>Thanks again for the support!</P><P>— Brisa</P><TABLE><TBODY><TR><TD>ID ACTIVITY</TD><TD>START TIME</TD><TD>END TIME</TD></TR><TR><TD>4e0c48e4</TD><TD>01/07/2025 07:21</TD><TD>02/07/2025 09:05</TD></TR><TR><TD>24069dc1</TD><TD>01/07/2025 07:22</TD><TD>01/07/2025 16:17</TD></TR><TR><TD>792309eb</TD><TD>01/07/2025 07:28</TD><TD>01/07/2025 16:14</TD></TR><TR><TD>1ac89f1f</TD><TD>01/07/2025 07:30</TD><TD>01/07/2025 16:10</TD></TR><TR><TD>7d6b3aaa</TD><TD>01/07/2025 07:32</TD><TD>01/07/2025 14:29</TD></TR><TR><TD>8f540261</TD><TD>01/07/2025 07:50</TD><TD>02/07/2025 09:19</TD></TR><TR><TD>95b767f6</TD><TD>01/07/2025 10:06</TD><TD>02/07/2025 09:47</TD></TR><TR><TD>712a5dbf</TD><TD>01/07/2025 14:29</TD><TD>01/07/2025 16:18</TD></TR><TR><TD>ecd6a751</TD><TD>01/07/2025 16:18</TD><TD>02/07/2025 08:36</TD></TR><TR><TD>109d5abd</TD><TD>02/07/2025 07:02</TD><TD>02/07/2025 08:27</TD></TR><TR><TD>670de4f5</TD><TD>02/07/2025 07:02</TD><TD>02/07/2025 08:37</TD></TR><TR><TD>d70f066a</TD><TD>02/07/2025 07:40</TD><TD>02/07/2025 16:19</TD></TR><TR><TD>15b59329</TD><TD>02/07/2025 09:14</TD><TD>02/07/2025 09:18</TD></TR><TR><TD>a4cafcf7</TD><TD>02/07/2025 09:48</TD><TD>02/07/2025 11:01</TD></TR><TR><TD>bbaa150e</TD><TD>02/07/2025 10:06</TD><TD>08/07/2025 09:16</TD></TR><TR><TD>bfe89f0c</TD><TD>02/07/2025 10:08</TD><TD>02/07/2025 10:18</TD></TR><TR><TD>bd8880f6</TD><TD>02/07/2025 11:02</TD><TD>02/07/2025 13:03</TD></TR><TR><TD>5abd6429</TD><TD>02/07/2025 13:05</TD><TD>02/07/2025 16:13</TD></TR><TR><TD>3b524ce2</TD><TD>02/07/2025 13:10</TD><TD>02/07/2025 13:19</TD></TR><TR><TD>dd6cdf54</TD><TD>03/07/2025 07:04</TD><TD>03/07/2025 16:15</TD></TR><TR><TD>9c3fdac7</TD><TD>03/07/2025 07:05</TD><TD>03/07/2025 16:16</TD></TR><TR><TD>0169c677</TD><TD>03/07/2025 07:17</TD><TD>03/07/2025 16:18</TD></TR><TR><TD>27b60207</TD><TD>03/07/2025 07:19</TD><TD>04/07/2025 16:00</TD></TR><TR><TD>5739bbcb</TD><TD>03/07/2025 07:20</TD><TD>08/07/2025 09:15</TD></TR><TR><TD>1fff1c9b</TD><TD>03/07/2025 07:23</TD><TD>03/07/2025 16:14</TD></TR><TR><TD>515a1299</TD><TD>03/07/2025 08:05</TD><TD>03/07/2025 16:14</TD></TR><TR><TD>f92da840</TD><TD>03/07/2025 08:07</TD><TD>07/07/2025 07:37</TD></TR><TR><TD>8008d046</TD><TD>03/07/2025 14:08</TD><TD>04/07/2025 09:16</TD></TR><TR><TD>3f345403</TD><TD>04/07/2025 07:49</TD><TD>04/07/2025 16:22</TD></TR><TR><TD>934444f3</TD><TD>04/07/2025 09:42</TD><TD>04/07/2025 09:43</TD></TR><TR><TD>aabaa29f</TD><TD>04/07/2025 09:52</TD><TD>04/07/2025 11:02</TD></TR><TR><TD>a95e6d93</TD><TD>04/07/2025 10:33</TD><TD>04/07/2025 16:15</TD></TR><TR><TD>10b08ee0</TD><TD>07/07/2025 07:16</TD><TD>07/07/2025 08:41</TD></TR><TR><TD>6ec4387c</TD><TD>07/07/2025 08:09</TD><TD>07/07/2025 13:07</TD></TR><TR><TD>dbc59872</TD><TD>07/07/2025 08:33</TD><TD>08/07/2025 07:59</TD></TR><TR><TD>c1e1ea2f</TD><TD>07/07/2025 08:41</TD><TD>07/07/2025 09:00</TD></TR><TR><TD>f2518d62</TD><TD>07/07/2025 09:43</TD><TD>08/07/2025 09:29</TD></TR><TR><TD>7615c22f</TD><TD>07/07/2025 13:07</TD><TD>07/07/2025 14:44</TD></TR><TR><TD>07b6850a</TD><TD>07/07/2025 14:44</TD><TD>08/07/2025 07:12</TD></TR><TR><TD>e83e78f6</TD><TD>07/07/2025 15:54</TD><TD>07/07/2025 16:11</TD></TR><TR><TD>ba7b18ca</TD><TD>08/07/2025 07:04</TD><TD>08/07/2025 08:53</TD></TR><TR><TD>257ecfd4</TD><TD>08/07/2025 07:10</TD><TD>08/07/2025 07:11</TD></TR><TR><TD>6c6c86b2</TD><TD>08/07/2025 07:10</TD><TD>08/07/2025 09:18</TD></TR><TR><TD>e4bda079</TD><TD>08/07/2025 07:12</TD><TD>08/07/2025 10:02</TD></TR><TR><TD>d023633d</TD><TD>08/07/2025 07:59</TD><TD>08/07/2025 14:44</TD></TR><TR><TD>7529231a</TD><TD>08/07/2025 09:30</TD><TD>08/07/2025 16:29</TD></TR><TR><TD>d78511db</TD><TD>08/07/2025 10:02</TD><TD>08/07/2025 16:01</TD></TR><TR><TD>5500fa35</TD><TD>08/07/2025 13:53</TD><TD>10/07/2025 14:53</TD></TR><TR><TD>b591a940</TD><TD>08/07/2025 14:44</TD><TD>09/07/2025 10:15</TD></TR><TR><TD>cb07ac88</TD><TD>09/07/2025 07:09</TD><TD>09/07/2025 07:58</TD></TR><TR><TD>dd7958c8</TD><TD>09/07/2025 07:09</TD><TD>09/07/2025 08:48</TD></TR><TR><TD>6febf55b</TD><TD>09/07/2025 07:11</TD><TD>09/07/2025 16:20</TD></TR><TR><TD>51a5c4ac</TD><TD>09/07/2025 07:58</TD><TD>09/07/2025 08:18</TD></TR><TR><TD>404a5c63</TD><TD>09/07/2025 08:18</TD><TD>09/07/2025 08:34</TD></TR><TR><TD>c4818946</TD><TD>09/07/2025 08:34</TD><TD>09/07/2025 09:44</TD></TR><TR><TD>c6f50ea2</TD><TD>09/07/2025 08:48</TD><TD>09/07/2025 14:39</TD></TR><TR><TD>de23c405</TD><TD>09/07/2025 10:21</TD><TD>10/07/2025 10:35</TD></TR><TR><TD>d028d2c8</TD><TD>09/07/2025 10:41</TD><TD>09/07/2025 11:08</TD></TR><TR><TD>0006d66a</TD><TD>09/07/2025 10:47</TD><TD>09/07/2025 10:54</TD></TR><TR><TD>2e8bcd96</TD><TD>09/07/2025 10:54</TD><TD>09/07/2025 16:20</TD></TR><TR><TD>a97055af</TD><TD>09/07/2025 11:10</TD><TD>09/07/2025 13:09</TD></TR><TR><TD>8543d598</TD><TD>09/07/2025 13:11</TD><TD>09/07/2025 15:28</TD></TR><TR><TD>fd040cad</TD><TD>09/07/2025 14:39</TD><TD>09/07/2025 15:56</TD></TR><TR><TD>1cd1ba41</TD><TD>09/07/2025 15:40</TD><TD>11/07/2025 07:56</TD></TR><TR><TD>4adbaf85</TD><TD>10/07/2025 07:13</TD><TD>10/07/2025 09:29</TD></TR><TR><TD>a1fc6ced</TD><TD>10/07/2025 07:33</TD><TD>10/07/2025 10:30</TD></TR><TR><TD>7adb0344</TD><TD>10/07/2025 07:34</TD><TD>10/07/2025 11:23</TD></TR><TR><TD>f03e7d71</TD><TD>10/07/2025 07:45</TD><TD>10/07/2025 07:46</TD></TR><TR><TD>dc60edb6</TD><TD>10/07/2025 07:46</TD><TD>10/07/2025 07:46</TD></TR><TR><TD>f3f0f163</TD><TD>10/07/2025 08:30</TD><TD>10/07/2025 10:41</TD></TR><TR><TD>1d294d3b</TD><TD>10/07/2025 09:29</TD><TD>10/07/2025 11:05</TD></TR><TR><TD>c16541a9</TD><TD>10/07/2025 10:30</TD><TD>11/07/2025 07:22</TD></TR><TR><TD>f3642705</TD><TD>10/07/2025 10:41</TD><TD>10/07/2025 13:26</TD></TR><TR><TD>0e1b9630</TD><TD>10/07/2025 11:05</TD><TD>10/07/2025 11:18</TD></TR><TR><TD>e5e621db</TD><TD>10/07/2025 11:13</TD><TD>10/07/2025 16:22</TD></TR><TR><TD>04acf5b0</TD><TD>10/07/2025 11:18</TD><TD>10/07/2025 11:43</TD></TR><TR><TD>130eaf91</TD><TD>10/07/2025 11:43</TD><TD>10/07/2025 13:23</TD></TR><TR><TD>91e6c8b0</TD><TD>10/07/2025 13:23</TD><TD>10/07/2025 14:06</TD></TR><TR><TD>de11d240</TD><TD>10/07/2025 13:26</TD><TD>11/07/2025 09:05</TD></TR><TR><TD>afc0b5aa</TD><TD>10/07/2025 14:53</TD><TD>11/07/2025 15:01</TD></TR><TR><TD>d82163de</TD><TD>11/07/2025 07:26</TD><TD>11/07/2025 08:57</TD></TR><TR><TD>23b07831</TD><TD>11/07/2025 08:02</TD><TD>14/07/2025 10:21</TD></TR><TR><TD>f55e0aa3</TD><TD>11/07/2025 07:30</TD><TD>11/07/2025 09:00</TD></TR><TR><TD>1b57370b</TD><TD>11/07/2025 09:19</TD><TD>11/07/2025 10:40</TD></TR><TR><TD>6c2633ac</TD><TD>11/07/2025 09:46</TD><TD>14/07/2025 10:03</TD></TR><TR><TD>0e40d102</TD><TD>11/07/2025 10:19</TD><TD>11/07/2025 16:03</TD></TR><TR><TD>aaac0df4</TD><TD>11/07/2025 10:40</TD><TD>11/07/2025 16:22</TD></TR><TR><TD>00f6501d</TD><TD>11/07/2025 14:35</TD><TD>14/07/2025 10:04</TD></TR><TR><TD>77b65cc4</TD><TD>14/07/2025 07:40</TD><TD>14/07/2025 07:47</TD></TR><TR><TD>6bba6576</TD><TD>14/07/2025 07:51</TD><TD>15/07/2025 07:12</TD></TR><TR><TD>ec2c1c95</TD><TD>14/07/2025 07:57</TD><TD>14/07/2025 16:25</TD></TR><TR><TD>966994d9</TD><TD>14/07/2025 08:06</TD><TD>&nbsp;</TD></TR><TR><TD>61767af7</TD><TD>14/07/2025 07:00</TD><TD>14/07/2025 08:37</TD></TR><TR><TD>0b523fa8</TD><TD>14/07/2025 08:40</TD><TD>14/07/2025 14:25</TD></TR><TR><TD>4dab9034</TD><TD>14/07/2025 08:53</TD><TD>14/07/2025 09:25</TD></TR><TR><TD>e4a87ec9</TD><TD>14/07/2025 10:25</TD><TD>14/07/2025 16:04</TD></TR><TR><TD>232dfba1</TD><TD>14/07/2025 10:56</TD><TD>14/07/2025 16:04</TD></TR><TR><TD>c3d5af56</TD><TD>14/07/2025 13:27</TD><TD>14/07/2025 16:27</TD></TR><TR><TD>e8d815d1</TD><TD>14/07/2025 13:55</TD><TD>15/07/2025 07:30</TD></TR><TR><TD>b808b452</TD><TD>14/07/2025 14:14</TD><TD>14/07/2025 16:29</TD></TR><TR><TD>f3c7efae</TD><TD>14/07/2025 14:54</TD><TD>15/07/2025 07:04</TD></TR><TR><TD>97186694</TD><TD>14/07/2025 21:27</TD><TD>&nbsp;</TD></TR><TR><TD>c4842be1</TD><TD>15/07/2025 07:01</TD><TD>&nbsp;</TD></TR><TR><TD>f899cc09</TD><TD>15/07/2025 07:04</TD><TD>15/07/2025 10:30</TD></TR><TR><TD>096ff292</TD><TD>15/07/2025 07:05</TD><TD>&nbsp;</TD></TR><TR><TD>47585dc1</TD><TD>15/07/2025 07:06</TD><TD>&nbsp;</TD></TR><TR><TD>d62fd73c</TD><TD>15/07/2025 07:07</TD><TD>&nbsp;</TD></TR><TR><TD>6338c4b0</TD><TD>15/07/2025 07:08</TD><TD>15/07/2025 13:05</TD></TR><TR><TD>a60d4376</TD><TD>15/07/2025 07:13</TD><TD>&nbsp;</TD></TR><TR><TD>e5b0d159</TD><TD>15/07/2025 07:30</TD><TD>&nbsp;</TD></TR><TR><TD>b174bacc</TD><TD>15/07/2025 08:07</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Tue, 15 Jul 2025 21:17:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4764315#M182504 brisacisnerosc 2025-07-15T21:17:55Z Re: How can I calculate elapsed working time within a date filter in Power BI? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4766572#M182590 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1309863" data-lia-user-login="brisacisnerosc" class="lia-mention lia-mention-user">brisacisnerosc</a>&nbsp;,</P> <P>Thank you for reaching out to Microsoft Fabric Community.</P> <P><SPAN>Thank you&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="645372" data-lia-user-login="techies" class="lia-mention lia-mention-user">techies</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1287762" data-lia-user-login="FBergamaschi" class="lia-mention lia-mention-user">FBergamaschi</a>&nbsp;</SPAN><SPAN>for the prompt response.</SPAN></P> <P><SPAN>I have implemented the working time logic considering working hours (07:00–16:30), excluding weekends, and deducting a 1-hour lunch break (12:00–13:00). The output dynamically responds to the date slicer and correctly shows blank where no activity overlaps the date.</SPAN></P> <P>&nbsp;</P> <P><SPAN>Please find the attached PBIX file for your reference.</SPAN></P> <P><SPAN>Thank you.</SPAN></P> <P>&nbsp;</P> <P><LI-WRAPPER></LI-WRAPPER></P> Thu, 17 Jul 2025 08:40:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4766572#M182590 v-venuppu 2025-07-17T08:40:17Z Re: How can I calculate elapsed working time within a date filter in Power BI? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4770060#M182684 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1309863" data-lia-user-login="brisacisnerosc" class="lia-mention lia-mention-user">brisacisnerosc</a>&nbsp;,</P> <P><SPAN>I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.</SPAN></P> <P><SPAN>Thank you.</SPAN></P> <P><LI-WRAPPER></LI-WRAPPER></P> <P><LI-WRAPPER></LI-WRAPPER></P> Mon, 21 Jul 2025 06:35:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4770060#M182684 v-venuppu 2025-07-21T06:35:20Z Re: How can I calculate elapsed working time within a date filter in Power BI? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4772643#M182775 <P>Hi @<A href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/1250613" target="_self"><SPAN class="">v-venuppu</SPAN></A>, thank you for your support and the working hours logic you’ve implemented — it's very helpful.</P><P>However, I’d like to clarify the scenario I’m working with:</P><P>Let’s say there is an activity that starts on <STRONG>July 9th</STRONG> and ends on <STRONG>July 11th</STRONG>. When I select <STRONG>only July 9th</STRONG> in the date slicer, I would expect to <STRONG>see only the working hours for July 9th</STRONG> — not the total across all days of the activity. Right now, since the activity spans multiple days, it also considers hours from July 10th and 11th, even if I only selected the 9th.</P><P>Similarly, if I select <STRONG>only July 11th</STRONG>, I want to see <STRONG>only the hours that correspond to that specific day</STRONG> — not accumulated from the 9th or 10th.</P><P>In summary, I’m looking for a solution where:</P><UL><LI><P>If a single day is selected, only the <STRONG>hours that fall strictly within that date</STRONG> are counted.</P></LI><LI><P>The logic should <STRONG>ignore any overlap from other days</STRONG> of a multi-day activity unless those days are selected as well.</P></LI></UL><P>Do you have any suggestions on how I could adjust the measure or filtering logic to achieve this?</P><P>Thanks again!</P> Tue, 22 Jul 2025 17:48:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4772643#M182775 brisacisnerosc 2025-07-22T17:48:05Z Re: How can I calculate elapsed working time within a date filter in Power BI? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4773241#M182799 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1309863" data-lia-user-login="brisacisnerosc" class="lia-mention lia-mention-user">brisacisnerosc</a>&nbsp;,</P> <P>Thank you for your Response..!!</P> <P>&nbsp;</P> <P>I have done the changes in the PBIX file by adjusting "Elapsed Working Hours" measure.Please go through the attached PBIX file.Let us know if you need any further assistance.</P> <P>Thank you.</P> <P>&nbsp;</P> Wed, 23 Jul 2025 07:46:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4773241#M182799 v-venuppu 2025-07-23T07:46:15Z Re: How can I calculate elapsed working time within a date filter in Power BI? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4778078#M183000 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1309863" data-lia-user-login="brisacisnerosc" class="lia-mention lia-mention-user">brisacisnerosc</a>&nbsp;,</P> <P>May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.</P> <P>Thank you.</P> <P><LI-WRAPPER></LI-WRAPPER></P> Mon, 28 Jul 2025 07:19:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-calculate-elapsed-working-time-within-a-date-filter-in/m-p/4778078#M183000 v-venuppu 2025-07-28T07:19:56Z