Forum Discussion

Drors's avatar
Drors
Resolver III
8 years ago
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          ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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] ) )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

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] ) )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

how about if i need it dublicated until todays month? i dont need it dublicated only 11 times!

thanks,