Double the rows in order to add the values from another column

[NewbiePowerBye]

Hello,

I have the following table:

ID    Phase1     Phase2

1      P1              P2

2      P2              P3

3      P4               P4

and the output I would want:

ID    Phase1     Phase2      Phase

1      P1              P2             P1

1      P1              P2             P2          

2      P2              P3             P2

2      P2              P3             P3

3      P4              P4             P4

I mention the Phase1 & Phase2 were created by DAX.

Can someone help me out on this?

[Stachu · Accepted solution]

are you using Direct query or is there another reason?
with DAX you can create calculated table (see syntax below), but AFAIK you cannot modify the table itself to that format, you would need to do that in PowerQuery

Table 2 = 
UNION(
    ADDCOLUMNS('Table',"Phase",[Phase1]),
    ADDCOLUMNS('Table',"Phase",[Phase2])
)

[v-juanli-msft · Accepted solution]

Hi @NewbiePowerBye

This calculated column can be replaced by Power Query as below

Best Regards

Maggie

[Stachu · Accepted solution]

basically do the following

1) add a custom column

{[Phase1],[Phase2]}

2) expand rows in that column

3) chagne type to text