Forum Discussion

sparvez's avatar
sparvez
Helper I
2 years ago

Display Sum

Hello Altruists,   A Table is given like below.  "Week"  will be increased or decreased randomly.   Person-- Week1-- Week2-- Week3-- ... Hoover-- 2-- 13-- 30-- ... Franklin-- 8-...
Need Help
sparvez's avatar
sparvez
Helper I
2 years ago

Hi, sorry, failed to open it, may be version issue. Could you please copy paste here the entire text of "Advanced Editor" ?  Thank you again

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

sparvez 

 

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8sjPL0stUtJRMgJiQ2MgYWygFKsTreRWlJiXnZOZBxSxAIkCsQlYwiczLzk/ByRuCcVGSrGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Person = _t, Week1 = _t, Week2 = _t, Week3 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Person", type text}, {"Week1", Int64.Type}, {"Week2", Int64.Type}, {"Week3", Int64.Type}}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Person"}, "Attribute", "Value"),
#"Renamed Columns" = Table.RenameColumns(#"Unpivoted Columns",{{"Attribute", "week nb"}})
in
#"Renamed Columns"



change the name of the table to your table name. 

 

or you can do  it by clicking on the 3 columns, and select unpivot table. 

 

if you have many columns that you want to pivot, 

you can select the first column, and click unpivot other columns, 

 

  • sparvez's avatar
    sparvez
    Helper I
    2 years ago

    Hi,  in this "entire advanced editor" text you posted in last reply,  text that you have mentioned in first reply ( below image) is missing. I am lost