topic Re: FInd Number of working Days betwwen the months in Developer https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3814346#M51526 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lbendlin_0-1712343850474.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1073341i0D7C2F6484748DBA/image-size/medium?v=v2&amp;px=400" role="button" title="lbendlin_0-1712343850474.png" alt="lbendlin_0-1712343850474.png" /></span></P> <P>&nbsp;</P> Fri, 05 Apr 2024 19:04:41 GMT lbendlin 2024-04-05T19:04:41Z FInd Number of working Days betwwen the months https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3808258#M51413 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hari4949_0-1712158336603.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1071776i470C1716A8B30FBE/image-size/medium?v=v2&amp;px=400" role="button" title="Hari4949_0-1712158336603.png" alt="Hari4949_0-1712158336603.png" /></span></P><P>I need the number of working days between the sr No and it was spread across 2 months and has Holidays in it</P> Wed, 03 Apr 2024 15:34:18 GMT https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3808258#M51413 Hari4949 2024-04-03T15:34:18Z Re: FInd Number of working Days betwwen the months https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3808954#M51422 <P>Please provide sample data that covers your issue or question <STRONG>completely</STRONG>, in a <STRONG>usable</STRONG> format (not as a screenshot).<BR /><BR />Do not include sensitive information or anything not related to the issue or question. <BR /><BR />If you are unsure how to upload data please refer to <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR /><BR />Please show the expected outcome based on the sample data you provided. <BR /><BR />Want faster answers? <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Wed, 03 Apr 2024 23:36:49 GMT https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3808954#M51422 lbendlin 2024-04-03T23:36:49Z Re: FInd Number of working Days betwwen the months https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3813838#M51514 <P>Sr NO Start Date End date Holiday Leave Net working Days Working Days Apr working Days May working Days June working Days 1 10-Apr-24 23-Apr-24 11-Apr-24 10 9 2 24-Apr-24 7-May-24 6-May-24 10 9 15 3 8-May-24 21-May-24 10 10 4 22-May-24 4-Jun-24 10 10 18 5 5-Jun-24 18-Jun-24 10 10 6 19-Jun-24 2-Jul-24 19</P><P>&nbsp;</P><P>&nbsp;</P><P>unable to attach</P> Fri, 05 Apr 2024 14:05:41 GMT https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3813838#M51514 Hari4949 2024-04-05T14:05:41Z Re: FInd Number of working Days betwwen the months https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3813840#M51515 <LI-CODE lang="markup">Sr NO Start Date End date Holiday Leave Net working Days Working Days Apr working Days May working Days June working Days 1 10-Apr-24 23-Apr-24 11-Apr-24 10 9 2 24-Apr-24 7-May-24 6-May-24 10 9 15 3 8-May-24 21-May-24 10 10 4 22-May-24 4-Jun-24 10 10 18 5 5-Jun-24 18-Jun-24 10 10 6 19-Jun-24 2-Jul-24 19</LI-CODE> Fri, 05 Apr 2024 14:06:08 GMT https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3813840#M51515 Hari4949 2024-04-05T14:06:08Z Re: FInd Number of working Days betwwen the months https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3814346#M51526 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lbendlin_0-1712343850474.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1073341i0D7C2F6484748DBA/image-size/medium?v=v2&amp;px=400" role="button" title="lbendlin_0-1712343850474.png" alt="lbendlin_0-1712343850474.png" /></span></P> <P>&nbsp;</P> Fri, 05 Apr 2024 19:04:41 GMT https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3814346#M51526 lbendlin 2024-04-05T19:04:41Z Re: FInd Number of working Days betwwen the months https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3822118#M51652 <P>Hi i want the Number of Networking days for the sprint and i want Dropdown with the month and should show Networking days</P><TABLE border="1"><TBODY><TR><TD>Sprint 2</TD><TD>24-Apr-24</TD><TD>7-May-24</TD></TR><TR><TD>Sprint 3</TD><TD>8-May-24</TD><TD>21-May-24</TD></TR><TR><TD>Sprint 4</TD><TD>22-May-24</TD><TD>4-Jun-24</TD></TR><TR><TD>Sprint 5</TD><TD>5-Jun-24</TD><TD>18-Jun-24</TD></TR><TR><TD>Sprint 6</TD><TD>19-Jun-24</TD><TD>2-Jul-24</TD></TR><TR><TD>Sprint 7</TD><TD>3-Jul-24</TD><TD>16-Jul-24</TD></TR><TR><TD>Sprint 8</TD><TD>17-Jul-24</TD><TD>30-Jul-24</TD></TR><TR><TD>Sprint 9</TD><TD>31-Jul-24</TD><TD>13-Aug-24</TD></TR><TR><TD>Sprint 10</TD><TD>14-Aug-24</TD><TD>27-Aug-24</TD></TR><TR><TD>Sprint 11</TD><TD>28-Aug-24</TD><TD>10-Sep-24</TD></TR><TR><TD>Sprint 12</TD><TD>11-Sep-24</TD><TD>24-Sep-24</TD></TR><TR><TD>Sprint 13</TD><TD>25-Sep-24</TD><TD>8-Oct-24</TD></TR><TR><TD>Sprint 14</TD><TD>9-Oct-24</TD><TD>22-Oct-24</TD></TR><TR><TD>Sprint 15</TD><TD>23-Oct-24</TD><TD>5-Nov-24</TD></TR></TBODY></TABLE> Tue, 09 Apr 2024 07:50:23 GMT https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3822118#M51652 Hari4949 2024-04-09T07:50:23Z Re: FInd Number of working Days betwwen the months https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3822123#M51653 <P>Expected output&nbsp;</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Sprint</TD><TD>Start Date</TD><TD>End date</TD><TD>Month</TD><TD>Net working Days</TD></TR><TR><TD>Sprint 1</TD><TD>10-Apr-24</TD><TD>23-Apr-24</TD><TD>Apr '24</TD><TD>15</TD></TR><TR><TD>Sprint 2</TD><TD>24-Apr-24</TD><TD>7-May-24</TD><TD>Apr '24</TD><TD>15</TD></TR><TR><TD>Sprint 2</TD><TD>24-Apr-24</TD><TD>7-May-24</TD><TD>May '24</TD><TD>22</TD></TR><TR><TD>Sprint 3</TD><TD>8-May-24</TD><TD>21-May-24</TD><TD>May</TD><TD>22</TD></TR><TR><TD>Sprint 4</TD><TD>22-May-24</TD><TD>4-Jun-24</TD><TD>May</TD><TD>22</TD></TR><TR><TD>Sprint 4</TD><TD>22-May-24</TD><TD>4-Jun-24</TD><TD>Jun</TD><TD>20</TD></TR><TR><TD>Sprint 5</TD><TD>5-Jun-24</TD><TD>18-Jun-24</TD><TD>Jun</TD><TD>20</TD></TR><TR><TD>Sprint 6</TD><TD>19-Jun-24</TD><TD>2-Jul-24</TD><TD>Jun</TD><TD>20</TD></TR><TR><TD>Sprint 6</TD><TD>19-Jun-24</TD><TD>2-Jul-24</TD><TD>Jul</TD><TD>23</TD></TR><TR><TD>Sprint 7</TD><TD>3-Jul-24</TD><TD>16-Jul-24</TD><TD>Jul</TD><TD>23</TD></TR><TR><TD>Sprint 8</TD><TD>17-Jul-24</TD><TD>30-Jul-24</TD><TD>Jul</TD><TD>23</TD></TR><TR><TD>Sprint 9</TD><TD>31-Jul-24</TD><TD>13-Aug-24</TD><TD>Aug</TD><TD>22</TD></TR><TR><TD>Sprint 10</TD><TD>14-Aug-24</TD><TD>27-Aug-24</TD><TD>Aug</TD><TD>22</TD></TR><TR><TD>Sprint 11</TD><TD>28-Aug-24</TD><TD>10-Sep-24</TD><TD>Aug</TD><TD>22</TD></TR><TR><TD>Sprint 11</TD><TD>28-Aug-24</TD><TD>10-Sep-24</TD><TD>sep</TD><TD>21</TD></TR><TR><TD>Sprint 12</TD><TD>11-Sep-24</TD><TD>24-Sep-24</TD><TD>sep</TD><TD>21</TD></TR><TR><TD>Sprint 13</TD><TD>25-Sep-24</TD><TD>8-Oct-24</TD><TD>sep</TD><TD>21</TD></TR><TR><TD>Sprint 13</TD><TD>25-Sep-24</TD><TD>8-Oct-24</TD><TD>Oct</TD><TD>23</TD></TR><TR><TD>Sprint 14</TD><TD>9-Oct-24</TD><TD>22-Oct-24</TD><TD>OCt</TD><TD>23</TD></TR><TR><TD>Sprint 15</TD><TD>23-Oct-24</TD><TD>5-Nov-24</TD><TD>Nov</TD><TD>13</TD></TR><TR><TD>Sprint 15</TD><TD>6-Nov-24</TD><TD>19-Nov-24</TD><TD>Nov</TD><TD>13</TD></TR></TBODY></TABLE> Tue, 09 Apr 2024 07:51:48 GMT https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3822123#M51653 Hari4949 2024-04-09T07:51:48Z Re: FInd Number of working Days betwwen the months https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3824220#M51665 <P>Your sample data and your expected outcome do not match</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lbendlin_0-1712677896794.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1075260i7535EA5B51E86196/image-size/medium?v=v2&amp;px=400" role="button" title="lbendlin_0-1712677896794.png" alt="lbendlin_0-1712677896794.png" /></span></P> <P>&nbsp;</P> Tue, 09 Apr 2024 15:51:44 GMT https://community.fabric.microsoft.com/t5/Developer/FInd-Number-of-working-Days-betwwen-the-months/m-p/3824220#M51665 lbendlin 2024-04-09T15:51:44Z