Multiples columns in 1 calculated table

[Shams7]

I have 1 table where there is 6 columns in 1 table like below

ID	Legal	DP	IT	Ops	Comp
ABC	InFlow	OutFlow	InFlow	InFlow	Missing
EFG	OutFlow	Inflow	OutFlow	OutFlow	Missing
IJK	Missing	Inflow	Missing	OutFlow	Missing
LMN	Inflow	Inflow	Missing	OutFlow	Missing

And i want to calculate new table like below.

ID	Type
ABC	InFlow
EFG	OutFlow
IJK	Missing
LMN	Inflow
ABC	OutFlow
EFG	Inflow
IJK	Inflow
LMN	Inflow
ABC	InFlow
EFG	OutFlow
IJK	Missing
LMN	Missing
ABC	InFlow
EFG	OutFlow
IJK	OutFlow
LMN	OutFlow
ABC	Missing
EFG	Missing
IJK	Missing
LMN	Missing

Can i do it like this, thanks in advance

[ThxAlot]

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcnRyVtJR8sxzy8kvBzL8S0ugLLgQnOGbWVycmZeuFKsTreTq5o6mOg3dAAQLWaOnlzeSCJJGhBB2jT6+fsjKidMXCwA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Legal = _t, DP = _t, IT = _t, Ops = _t, Comp = _t]),

    #"Added Index" = Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type),
    #"Unpivoted Other Columns" = Table.RemoveColumns(Table.UnpivotOtherColumns(#"Added Index", {"Index"}, "Id", "Type"), {"Index"})
in
    #"Unpivoted Other Columns"

[Shams7]

This will not feasible as all other columns except ID is calculated columns, please suggest another way

[Fowmy]

@Shams7 

Use Power Query to do it using UnPivot functionality: https://www.youtube.com/watch?v=IULqUeYEnto&pp=ygUJZXhjZWxmb3J0

[Shams7]

This will not feasible as all other columns except ID is calculated columns, please suggest another way

[Fowmy · Accepted solution]

@Shams7 

To create a table using DAX, here is the code. Replace Table04 with your table name.

New Table Name = 
	UNION(
		SELECTCOLUMNS('Table04', "ID", 'Table04'[ID], "Type", 'Table04'[Legal]),
		SELECTCOLUMNS('Table04', "ID", 'Table04'[ID], "Type", 'Table04'[DP]),
		SELECTCOLUMNS('Table04', "ID", 'Table04'[ID], "Type", 'Table04'[IT]),
		SELECTCOLUMNS('Table04', "ID", 'Table04'[ID], "Type", 'Table04'[Ops]),
		SELECTCOLUMNS('Table04', "ID", 'Table04'[ID], "Type", 'Table04'[Comp])
	)