Forum Discussion
Return all week numbers in a range
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
Super UserHi,
Share the download link of the PBI file. In that file, ensure that there is a Calendar table with a week column.
Thank you,
Unfortunately, I'm getting a "The date column must have unique values." message when I attempt to created a date table. Please see the sample data link below:
- Ashish_Mathur
That 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 - Ashish_Mathur
As requested, please also share a Calendar table with a week number column (since i do not know what the start and end of week is for you). Also, for a few rows of the sample data, show the expected result.