FInd Number of working Days betwwen the months

[Hari4949]

I need the number of working days between the sr No and it was spread across 2 months and has Holidays in it

[Hari4949]

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

[lbendlin]

[Hari4949]

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

unable to attach

[Hari4949]

Hi i want the Number of Networking days for the sprint and i want Dropdown with the month and should show Networking days

Sprint 2	24-Apr-24	7-May-24
Sprint 3	8-May-24	21-May-24
Sprint 4	22-May-24	4-Jun-24
Sprint 5	5-Jun-24	18-Jun-24
Sprint 6	19-Jun-24	2-Jul-24
Sprint 7	3-Jul-24	16-Jul-24
Sprint 8	17-Jul-24	30-Jul-24
Sprint 9	31-Jul-24	13-Aug-24
Sprint 10	14-Aug-24	27-Aug-24
Sprint 11	28-Aug-24	10-Sep-24
Sprint 12	11-Sep-24	24-Sep-24
Sprint 13	25-Sep-24	8-Oct-24
Sprint 14	9-Oct-24	22-Oct-24
Sprint 15	23-Oct-24	5-Nov-24

[Hari4949]

Expected output 

Sprint	Start Date	End date	Month	Net working Days
Sprint 1	10-Apr-24	23-Apr-24	Apr '24	15
Sprint 2	24-Apr-24	7-May-24	Apr '24	15
Sprint 2	24-Apr-24	7-May-24	May '24	22
Sprint 3	8-May-24	21-May-24	May	22
Sprint 4	22-May-24	4-Jun-24	May	22
Sprint 4	22-May-24	4-Jun-24	Jun	20
Sprint 5	5-Jun-24	18-Jun-24	Jun	20
Sprint 6	19-Jun-24	2-Jul-24	Jun	20
Sprint 6	19-Jun-24	2-Jul-24	Jul	23
Sprint 7	3-Jul-24	16-Jul-24	Jul	23
Sprint 8	17-Jul-24	30-Jul-24	Jul	23
Sprint 9	31-Jul-24	13-Aug-24	Aug	22
Sprint 10	14-Aug-24	27-Aug-24	Aug	22
Sprint 11	28-Aug-24	10-Sep-24	Aug	22
Sprint 11	28-Aug-24	10-Sep-24	sep	21
Sprint 12	11-Sep-24	24-Sep-24	sep	21
Sprint 13	25-Sep-24	8-Oct-24	sep	21
Sprint 13	25-Sep-24	8-Oct-24	Oct	23
Sprint 14	9-Oct-24	22-Oct-24	OCt	23
Sprint 15	23-Oct-24	5-Nov-24	Nov	13
Sprint 15	6-Nov-24	19-Nov-24	Nov	13

[lbendlin]

Your sample data and your expected outcome do not match

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...