Forum Discussion
Index column in Power Query
I have a table in SQL that loads in Power BI, in that table has only a Number column. I Want to know if there is any way to create the index column in Power Query? The index column c...
Hi Anonymous
There is an option Create Index Column (From 1) in Power Query Editor mode. So, add this index column.
next, add a Custom column:
= Number.RoundUp([Index]/5)full power query example:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("HcS5DQAgDATBXi6mI8sBYH7oP0XaCcZMWZ5MhSsHN+48ePLizYcvP7l/", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1), #"Added Custom" = Table.AddColumn(#"Added Index", "Custom", each Number.RoundUp([Index]/5)), #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Index"}) in #"Removed Columns"do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi Anonymous
There is an option Create Index Column (From 1) in Power Query Editor mode. So, add this index column.
next, add a Custom column:
= Number.RoundUp([Index]/5)full power query example:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("HcS5DQAgDATBXi6mI8sBYH7oP0XaCcZMWZ5MhSsHN+48ePLizYcvP7l/", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1),
#"Added Custom" = Table.AddColumn(#"Added Index", "Custom", each Number.RoundUp([Index]/5)),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Index"})
in
#"Removed Columns"do not hesitate to give a kudo to useful posts and mark solutions as solution
Thank you az38 .