Add rows based on conditions met

[gojohnson]

I am working to transform data from monthly totals to weekly totals. I can use a simple division to break the monthly forecast into weekly totals. Each line of the data shown also has a product and plant codes in addition to the date and sum(forecast). However, the date and forecast columns are the ones that need broken down. So each 1/1/2022 date needs to be broken down to 1/3/2022, 1/10/2022, 1/17/2022, 1/24/2022, and 1/31/2022. The totals for each date would be the same for each date. How do I add rows for the adjusted dates with the new forecast totals?

[slorin · Accepted solution]

Hi,

add column

List.Select(List.Dates([Date],Date.Day(Date.EndOfMonth([Date])),#duration(1,0,0,0)), each Date.DayOfWeek(_)=0)

 and expand this new column to rows

Stéphane