Convert few columns into rows in an existing table

Hi pointtoshare,

 

If we Unpivot these 4 columns: E,F,G,H, we will get below result.  The other columns are still kept as original.  From the image which is your expected output, I am confused why each record repeats for three times.

 

To your second question"can I convert columns into rows in a calculated table", it is not available to pivot/unpivot a calculated table in query editor mode. However, to work around this issue, please try below DAX:

New Table =
UNION (
    SELECTCOLUMNS (
        'Convert column',
        "A", 'Convert column'[A],
        "Col1", "E",
        "Col2", 'Convert column'[E]
    ),
    SELECTCOLUMNS (
        'Convert column',
        "A", 'Convert column'[A],
        "Col1", "F",
        "Col2", 'Convert column'[F]
    ),
    SELECTCOLUMNS (
        'Convert column',
        "A", 'Convert column'[A],
        "Col1", "G",
        "Col2", 'Convert column'[G]
    ),
    SELECTCOLUMNS (
        'Convert column',
        "A", 'Convert column'[A],
        "Col1", "H",
        "Col2", 'Convert column'[H]
    )
)

 

Best regards,
Yuliana Gu