Forum Discussion

gojohnson's avatar
gojohnson
Frequent Visitor
2 years ago
Solved

Add rows based on conditions met

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 p...
Need Help
  • slorin's avatar
    slorin
    2 years ago

    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

slorin's avatar
slorin
Super User
2 years ago

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