Adding rows dynamically to a table

Hi Anonymous ,

According to my understand, you want to dynamically add rows based on the original table, right?

I did it in two ways.  And here is my pbix file.

1.Use DAX

UnionedTable =
VAR _allNames =
    ALLSELECTED ( Table1[Name] )
VAR _newTable =
    ADDCOLUMNS ( _allNames, "New", "All" )
RETURN
UNION ( Table1, _newTable )

2.Follow these steps in Query Editor:

Add a custom column(set value as “All”) -->Select the Name column ,use “unpivot other Columns”-->Delete the "Attribute" column ,then the table will be transformed as what you want :

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSAeJYnWglJyDLCcxyBrKcwSwXIMsFzHIFslyVYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, Category = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Category", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "newColumn", each "All"),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Added Custom", {"Name"}, "Attribute", "Value"),
    #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Other Columns",{"Attribute"})
in
    #"Removed Columns"

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin