promote 4th row as header

Hi sudhav ,

You can consider using conditional columns with sorting to solve.

Suppoese we have a table like this:

Again, we want to use the fourth record as the title.

Add a conditional column:

Sorting conditional column:

Use the first row as the headers and remove the conditional column.

result:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("JYy5DcAwDAN3Ue3CVBzHKfNsIWj/NUIqxRHEgWCEwZo52ciwbGE72yQHWWVONnSF1vCSF+tNHvKWgT4wFPrA/K1+sBT68W6ZHw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t, Column4 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}}),
    #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [Column1] = "A" then 1 else null),
    #"Sorted Rows" = Table.Sort(#"Added Conditional Column",{{"Custom", Order.Descending}}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Sorted Rows", [PromoteAllScalars=true]),
    #"Removed Columns" = Table.RemoveColumns(#"Promoted Headers",{"1"})
in
    #"Removed Columns"

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum