Forum Discussion
Index Calculated columns
Hi I need to add the calculated index column to the table by a DAX formula. Rgds Henrik
Hi Anonymous,
It seems like a multiple column sort recruitment, maybe you can take a look at following thread about using isonorafter to sort multiple columns:
Regards,
Xiaoxin Sheng
Hi Anonymous
I think you have to do it with Power Query like this:
// Table
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("pdM9DoAgDAXguzBrLC0qjEY8AWzGG3j/2Z9oECbiSxgK6fdoQlhX5VhTF5cQVaO+i2n2YkSrrcmb7noi/ZbXcbsXjvt6l3acRQx4xIhHWDzCwRFC+BTmE1G8tSEfWDTnHc8NnDJLIBUgjSOZNYDtATsAdgSsBaz7b5kAe37+7QA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [A = _t, B = _t, C = _t, D = _t, E = _t, KEY = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"A", type text}, {"B", type text}, {"C", type text}, {"D", type text}, {"E", type text}, {"KEY", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"A"}, {{"Gruppieren", each _, type table [A=text, B=text, C=text, D=text, E=text, KEY=text]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Index", each Table.AddIndexColumn([Gruppieren], "Index", 1, 1)),
#"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Index"}),
#"Expanded {0}" = Table.ExpandTableColumn(#"Removed Other Columns", "Index", {"A", "B", "C", "D", "E", "KEY", "Index"}, {"A", "B", "C", "D", "E", "KEY", "Index.1"})
in
#"Expanded {0}"
Regards FrankAT