Unpivot calculated columns

[AGo]

Is it possible to unpivot some calculated columns with one of the Power BI Desktop tools or using DAX? I have 8 calculated columns titled with the type of the event valued with date format.

[v-yulgu-msft · Accepted solution]

Hi @AGo,

In PowerBI desktop, we can only unpivot table in Query Edit. It is not allowed to use DAX to change the table structure. And as you know, calculated columns will not display in Query edit, so your requirement cannot be achieved currently.

Thanks,
Yuliana Gu

[ronil_shah]

Is there any other way to do this please?

[omrdmr]

Hi @v-yulgu-msft, 

Is this limitation still in force? Have there been any changes since Sep'16?

I have a hierarchy table which has columns for levels up to 20; created using path function in DAX. I need to get every node associated with a different table. To my knowledge, this is only possible by unpivoting columns to have only 2 columns; parents and all linked children. As the hierarchy is identified in DAX, the rest must be done using DAX as well.

An example of the desired output based on the given hierarchy table:

Hierarchy table created with the help of DAX  PATH function 

Level1	Level2	Level3	Level4
A	B	C	D
A	B	C	F
A	B	G
A	H
Desired Output:
Parents	Children
A	B
A	C
A	D
A	F
A	G
A	H
B	C
B	D
B	F
B	G
C	D
C	F