Forum Discussion
Solved
Duplicate rows with new values
Hi, I have a table like that : Customer|Date|amount I need to duplicate each row 12 times each time with the next month example: original row customer | Date | amount 1 ...
Hi Drors
Try this solution
Go to Modelling Tab>>> New Table
New Table = GENERATE ( TableName, VAR mymonth = MONTH ( TableName[Date] ) RETURN GENERATESERIES ( 0, 11, 1 ) )Now Add this CALCULATED COLUMN to your NEW TABLE
New date = DATE ( YEAR ( 'New Table'[Date] ), MONTH ( 'New Table'[Date] ) + 'New Table'[Value], DAY ( 'New Table'[Date] ) )
wow thank you it works!
Do you have any idea how to do it with a regular table and not calculated one, I think it will make my work difficault later..
and again, Thank you very much, I work on it all day
This would be my Power Query solution:
let Source = TableName, DateList = Table.TransformColumns(Source,{{"Date", (startdate) => List.Transform({0..11}, each Date.AddMonths(startdate,_)), type {date}}}), #"Expanded Date" = Table.ExpandListColumn(DateList, "Date") in #"Expanded Date"Thank you its working!
