Forum Discussion

Luque's avatar
Luque
Frequent Visitor
7 years ago
Solved

Duplicate row by value

Hello everyone,  I need help with the process to duplicate a row by the value on one specific column.    I have this table (example) :                               I need th...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Luque,

     

    Based on above sample dataset, please create a calculated table with below DAX.

    Table_2 =
VAR tempTable =
    FILTER (
        Table_1,
        Table_1[Cancelation reason] = "PS-002"
            || Table_1[Cancelation reason] = "PS-003"
    )
RETURN
    UNION (
        Table_1,
        SELECTCOLUMNS (
            tempTable,
            "No", [No],
            "Due Date", [Document Date],
            "Document Date", [Document Date],
            "Cancelation reason", BLANK (),
            "Amount", [Amount]
        )
    )

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Luque,

 

Based on above sample dataset, please create a calculated table with below DAX.

Table_2 =
VAR tempTable =
    FILTER (
        Table_1,
        Table_1[Cancelation reason] = "PS-002"
            || Table_1[Cancelation reason] = "PS-003"
    )
RETURN
    UNION (
        Table_1,
        SELECTCOLUMNS (
            tempTable,
            "No", [No],
            "Due Date", [Document Date],
            "Document Date", [Document Date],
            "Cancelation reason", BLANK (),
            "Amount", [Amount]
        )
    )

 

Best regards,

Yuliana Gu

Luque's avatar
Luque
Frequent Visitor
7 years ago

Thank you so much!

 

Its exactly what i need. 

 

Regards!