Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!
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
If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS
Thanks
Pijush
Proud to be a 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,