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

Ruksuro's avatar
Ruksuro
Helper III
7 years ago

Why are you trying to duplicate rows, what is the end goal here?

 

If you are trying to double count the rows then maybe a calculated column would help, such as (psuedocode):

 

If Value 3 is "PS02" or "PS03 then 2 else 1

 

and then sum the new column as a measure?

  • Luque's avatar
    Luque
    Frequent Visitor
    7 years ago

    Hi Ruksuro, thanks for the reply.

     

    I need to duplicate rows because in my report i need to show the same row in a matrix but in different dates at same time, and just in specific situations.

     

    I have to do that because in the source data (SQL Server from Microsoft Dynamics Nav 2009), the row i have to show is being updating instead of creating a new one, so i have to duplicate it.

     

    Its like that:

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Thanks again, and i hope i explained myself.

    • 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!