Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
My Dataset
ID | Date (Of Extract) | Iteration Start Date | Iteration End Date | Remaining Hours |
1 | 15/08/22 | 15/08/22 | 25/08/22 | 10 |
1 | 16/08/22 | 15/08/22 | 25/08/22 | 9 |
2 | 15/08/22 | 15/08/22 | 25/08/22 | 12 |
2 | 16/08/22 | 15/08/22 | 25/08/22 | 6 |
@dswallow , Based on what I got you can generate all the dates using one these two method and use that column
DAX
Power query
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
User | Count |
---|---|
89 | |
73 | |
69 | |
64 | |
56 |
User | Count |
---|---|
98 | |
92 | |
84 | |
74 | |
66 |