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 guys,
Could you help me with difficulty bellow?
I need creat a sequencebeging from 1 acording with the colum "Picking hour", but when the colum NF change I need to restart the sequence from 1 again.
Bellow one exemple that I need
Thanks a lot
Solved! Go to Solution.
You can do this by grouping on [NF] keeping All Rows
And then edit the code generated to add an index column to each group.
Full M query example you can paste into the Advanced Editor after creating a new Blank Query:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTI1VYrVgTLNEEwLMNMJyDQwRDBNwExnINPECME0RjCRFJgrxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [NF = _t, #"Picking hour" = _t]),
#"Grouped Rows" = Table.Group(Source, {"NF"}, {{"Subtable", each Table.AddIndexColumn(_, "Order", 1, 1), type table}}),
#"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Subtable", {"Picking hour", "Order"}, {"Picking hour", "Order"})
in
#"Expanded Count"
You can do this by grouping on [NF] keeping All Rows
And then edit the code generated to add an index column to each group.
Full M query example you can paste into the Advanced Editor after creating a new Blank Query:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTI1VYrVgTLNEEwLMNMJyDQwRDBNwExnINPECME0RjCRFJgrxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [NF = _t, #"Picking hour" = _t]),
#"Grouped Rows" = Table.Group(Source, {"NF"}, {{"Subtable", each Table.AddIndexColumn(_, "Order", 1, 1), type table}}),
#"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Subtable", {"Picking hour", "Order"}, {"Picking hour", "Order"})
in
#"Expanded Count"
It worked Alexis!!
Thanks so much!!
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 |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |