Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm trying to add an incremental index calculated by a group like that:
Key | Row_Id |
123prod1_2016 | 1 |
123prod1_2016 | 2 |
123prod1_2016 | 3 |
456prod2_2017 | 1 |
456prod2_2017 | 2 |
456prod2_2017 | 3 |
I found this function but doesn't work (the output is 1 for all rows):
=RANKX(FILTER(Table;EARLIER(Table[Key])=Table[Key]);Table[Key])
Thanks for the help
Solved! Go to Solution.
Hi @nanoshi,
You can do that using M Language,
Just click on Edit Queries and Advanced Editor and type this code replacing the table name/source
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQyjg8I8ndRitXBxzExNSPIiQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Key = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Key", type text}}),
#"Group" = Table.Group(#"Changed Type", {"Key"}, {{"Rows", each Table.AddIndexColumn(_,"Index", 1), type table}}),
#"Expanded" = Table.ExpandTableColumn(#"Group", "Rows", {"Key", "Index"}, {"Rows.Key", "Rows.Index"}),
#"Removed Columns" = Table.RemoveColumns(Expanded,{"Rows.Key"})
in
#"Removed Columns"
Hi @nanoshi,
You can do that using M Language,
Just click on Edit Queries and Advanced Editor and type this code replacing the table name/source
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQyjg8I8ndRitXBxzExNSPIiQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Key = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Key", type text}}),
#"Group" = Table.Group(#"Changed Type", {"Key"}, {{"Rows", each Table.AddIndexColumn(_,"Index", 1), type table}}),
#"Expanded" = Table.ExpandTableColumn(#"Group", "Rows", {"Key", "Index"}, {"Rows.Key", "Rows.Index"}),
#"Removed Columns" = Table.RemoveColumns(Expanded,{"Rows.Key"})
in
#"Removed Columns"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |