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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.