Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

change row values to column names

Hi , I want to change row values to column names. In the Power BI query there is Pivot column option, but since I have two columns as value, that solution did not work for me.

Thanks in advance!

Post_Forum.PNG

2 REPLIES 2
PijushRoy
Super User
Super User

Hi @Anonymous 

Please create a Blank query in PQ and paste the code in Advance Editor

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMtI1MAQiJR0lRyAGChgaGoG5LqkFiUUlual5JUCOU2Y+lIzVwa/NOR+mJTEJCIGMvNKcHMLaMksyq1LzYvKAbLcgRygZGwsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Date#(lf)" = _t, Database = _t, Identity = _t, Names = _t, Source1 = _t, Source2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date#(lf)", type date}, {"Database", type text}, {"Identity", Int64.Type}, {"Names", type text}, {"Source1", type text}, {"Source2", type text}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Date#(lf)", "Database", "Identity", "Names"}, "Attribute", "Value"),
    #"Pivoted Column" = Table.Pivot(#"Unpivoted Columns", List.Distinct(#"Unpivoted Columns"[Names]), "Names", "Value"),
    #"Renamed Columns" = Table.RenameColumns(#"Pivoted Column",{{"Attribute", "Source"}})
in
    #"Renamed Columns"

 

Image

PijushRoy_0-1701878403886.png


If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

Thanks
Pijush

rsbin
Super User
Super User

@Anonymous ,

You need to use a combination of Unpivot Columns and Pivot Columns.

Please see attached pbix file for detailed Power Query Transformation steps.  Trust you can follow along.

In the future, please paste sample data as text, not as a picture.  This will make it easier for folks to assist.

Regards,

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors