Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Hari4949
Frequent Visitor

FInd Number of working Days betwwen the months

Hari4949_0-1712158336603.png

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

7 REPLIES 7
Hari4949
Frequent Visitor

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_0-1712343850474.png

 

Hari4949
Frequent Visitor

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

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

Sprint 224-Apr-247-May-24
Sprint 38-May-2421-May-24
Sprint 422-May-244-Jun-24
Sprint 55-Jun-2418-Jun-24
Sprint 619-Jun-242-Jul-24
Sprint 73-Jul-2416-Jul-24
Sprint 817-Jul-2430-Jul-24
Sprint 931-Jul-2413-Aug-24
Sprint 1014-Aug-2427-Aug-24
Sprint 1128-Aug-2410-Sep-24
Sprint 1211-Sep-2424-Sep-24
Sprint 1325-Sep-248-Oct-24
Sprint 149-Oct-2422-Oct-24
Sprint 1523-Oct-245-Nov-24

Expected output 

 

SprintStart DateEnd dateMonthNet working Days
Sprint 110-Apr-2423-Apr-24Apr '2415
Sprint 224-Apr-247-May-24Apr '2415
Sprint 224-Apr-247-May-24May '2422
Sprint 38-May-2421-May-24May22
Sprint 422-May-244-Jun-24May22
Sprint 422-May-244-Jun-24Jun20
Sprint 55-Jun-2418-Jun-24Jun20
Sprint 619-Jun-242-Jul-24Jun20
Sprint 619-Jun-242-Jul-24Jul23
Sprint 73-Jul-2416-Jul-24Jul23
Sprint 817-Jul-2430-Jul-24Jul23
Sprint 931-Jul-2413-Aug-24Aug22
Sprint 1014-Aug-2427-Aug-24Aug22
Sprint 1128-Aug-2410-Sep-24Aug22
Sprint 1128-Aug-2410-Sep-24sep21
Sprint 1211-Sep-2424-Sep-24sep21
Sprint 1325-Sep-248-Oct-24sep21
Sprint 1325-Sep-248-Oct-24Oct23
Sprint 149-Oct-2422-Oct-24OCt23
Sprint 1523-Oct-245-Nov-24Nov13
Sprint 156-Nov-2419-Nov-24Nov13

Your sample data and your expected outcome do not match

 

lbendlin_0-1712677896794.png

 

lbendlin
Super User
Super User

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...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.