March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
I need the number of working days between the sr No and it was spread across 2 months and has Holidays in it
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
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 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 |
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 |
Your sample data and your expected outcome do not match
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...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!