table data presentation

Well, the problem I got stuck to in referencing the columnnames rather than the values in those columns. I was thinking something allong the lines of using UNION() and SELECTEDCOLUMNS() to create a new table but because you also want to keep the original columns it isn't really an unpivot action. 

Few questions: are the column names static or do you want this to be dynamic? Can you change the source? Do you want this to be done in power query or in DAX?

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Kudo's are welcome 🙂

Anonymous tranform the data in power query, copy following script and then use matrix visual to product the result

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSs5ILMrJTFXSUTI0NAKSRsaGSrE60UqpRZnJYK4JkDQ2MlKKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t, col1_fd = _t, col2_rd = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"col1_fd", Int64.Type}, {"col2_rd", Int64.Type}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Name"}, "Attribute", "Value"),
    #"Inserted Text After Delimiter" = Table.AddColumn(#"Unpivoted Other Columns", "col_tag", each Text.AfterDelimiter([Attribute], "_"), type text),
    #"Added Custom" = Table.AddColumn(#"Inserted Text After Delimiter", "Name New", each ([Name]&" " &[col_tag]), type text),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Name", "col_tag"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Name New", "Name"}})
in
    #"Renamed Columns"