Forum Discussion
Solved
Return all week numbers in a range
I have a large number of start and stop dates that align with employee identification numbers, and I want a count of all of the weeks that their ranges cover. Can I do this in Power BI? Thank you! ...
You've provided your expected result but the solution depends on the actual data. We don't know what your tables look like. Are the weeks broken down into days or just a week start and end dates? Assuming that's the structure of your weeks table, please see the attached sample pbix
Ashish_Mathur
Super User
Super UserThat takes me to a sign-in page.
Sorry...I'm new to the solution and can't figure out how to share outside of my organization. However, the data is very simple:
| TM# | LWD Total | RWD Total | Absence Day Counts Lost Restricted Date | LWD End Date | RWD End Date |
| 368 | 0 | 20 | 6/10/2024 | 6/10/2024 | 6/30/2024 |
| 9072 | 0 | 2 | 7/1/2024 | 7/1/2024 | 7/3/2024 |
| 428 | 0 | 12 | 3/20/2025 | 3/20/2025 | 4/1/2025 |
| 1286 | 0 | 30 | 4/1/2025 | 4/1/2025 | 5/1/2025 |
| 8777 | 0 | 31 | 5/1/2025 | 5/1/2025 | 6/1/2025 |
| 472 | 0 | 11 | 6/1/2025 | 6/1/2025 | 6/12/2025 |
| 1110 | 0 | 19 | 7/1/2025 | 7/1/2025 | 7/20/2025 |
| 231 | 0 | 2 | 7/30/2025 | 7/30/2025 | 8/1/2025 |
| 5490 | 0 | 31 | 8/1/2025 | 8/1/2025 | 9/1/2025 |
| 7929 | 0 | 30 | 9/1/2025 | 9/1/2025 | 10/1/2025 |
| 188 | 0 | 16 | 10/1/2025 | 10/1/2025 | 10/17/2025 |
| 5159 | 0 | 16 | 4/15/2024 | 4/15/2024 | 5/1/2024 |
| 8646 | 0 | 31 | 5/1/2024 | 5/1/2024 | 6/1/2024 |
| 9271 | 0 | 3 | 6/1/2024 | 6/1/2024 | 6/4/2024 |
| 644 | 0 | 1 | 3/31/2025 | 3/31/2025 | 4/1/2025 |
| 2458 | 0 | 30 | 4/1/2025 | 4/1/2025 | 5/1/2025 |
| 859 | 0 | 31 | 5/1/2025 | 5/1/2025 | 6/1/2025 |
| 1298 | 0 | 30 | 6/1/2025 | 6/1/2025 | 7/1/2025 |
| 9255 | 31 | 0 | 7/1/2025 | 8/1/2025 | 7/1/2025 |
| 6337 | 19 | 0 | 8/1/2025 | 8/20/2025 | 8/1/2025 |
| 9938 | 0 | 5 | 9/26/2024 | 9/26/2024 | 10/1/2024 |
| 3806 | 0 | 16 | 10/1/2024 | 10/1/2024 | 10/17/2024 |
| 2466 | 0 | 3 | 4/28/2025 | 4/28/2025 | 5/1/2025 |
| 5099 | 0 | 31 | 5/1/2025 | 5/1/2025 | 6/1/2025 |
| 6094 | 0 | 30 | 6/1/2025 | 6/1/2025 | 7/1/2025 |
| 4637 | 0 | 10 | 7/1/2025 | 7/1/2025 | 7/11/2025 |
| 900 | 1 | 19 | 9/1/2025 | 9/2/2025 | 9/20/2025 |