I just saw this answer. Is there a way I could duplicate rows based on dates? I receive data with a start date for a weekly production volume. I'm having trouble figuring out in DAX how I can write a measure to show that weekly data in a pivot table - that production is happening in the next week but there's no record of it. So I'm wondering if the answer is to duplicate the weekly data in the original query.
So for a production facility with a lifespan of (say) 5 years, I would like to duplicate the rows incrementing the week on each row up until the 5 year mark. If I add production in year 2 then I would only want 4 * 52 rows of data, and so on.