Hi, @roncruiser
The complete code, I've changed it, you just need to follow the picture below to modify the parameters to achieve your desired effect.
// output
let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
chType = Table.TransformColumnTypes(Source,{{"Delay", type number}}),
fx = (tbl as table, Coarse_start as number, Fine_start as number, Fine_end as number)=>
let
sortedTbl = Table.Sort(tbl, {"Delay", 0}),
rows = List.Buffer(Table.ToRows(sortedTbl)),
n = List.Count(rows),
gen = List.Generate(
()=>{0, {}, 0},//{counter, {new_list}, delay_counter}
each _{0}<=n,
each let count = Fine_end+1-Fine_start,
Index1 = _{0},
Coarse = Number.IntegerDivide(_{0}, count)+Coarse_start,
Fine = Number.Mod(_{0}, count)+Fine_start
in {_{0}+1, {Index1, Coarse, Fine}, _{0}},
each List.InsertRange(rows{_{2}}, 4, _{1})
),
toTbl = Table.FromRows(
List.Skip(gen),
List.InsertRange(
Table.ColumnNames(sortedTbl),
4,
{"Index1", "Coarse", "Fine"}
)
)
in
toTbl,
group = Table.Group(chType, "Ref", {"t", each fx(_, 3, 4, 11)})[t],
result = Table.Combine(group)
in
result
Hi, @roncruiser
Change the code for the query called Example in the sample file you uploaded to the Google Drive to the following:
// Example
let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
fnRec = (tbl)=> List.Transform({0..Table.RowCount(tbl)}, each [Index1=_, Index2=Number.IntegerDivide(_, 10), Index3=Number.Mod(_, 10)]),
fx = Function.ScalarVector(
type function(rec as text) as text,
(tbl)=>
let t=Table.Buffer(tbl) in fnRec(t)
),
group = Table.Group(Source, {"Ref"}, {"SubIndexes", each Table.AddColumn(_, "rec", (r)=>fx(r))})[SubIndexes],
cmbTbls = Table.Combine(group),
expd = Table.ExpandRecordColumn(cmbTbls, "rec", {"Index1", "Index2", "Index3"})
in
expd
The result of the code run is shown below:
@roncruiser - perhaps you could provide some specific data with expected results that would help us see what you are doing. To me, it seems you can just add an index, then add another sub-index of 0-4 using this code.
let
Source = {0..10},
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), {"First Index"}, null, ExtraValues.Error),
#"Added Custom" = Table.AddColumn(#"Converted to Table", "Second Index", each {1..4}),
#"Expanded Second Index" = Table.ExpandListColumn(#"Added Custom", "Second Index")
in
#"Expanded Second Index"
But without data, we are just guessing. See links at bottom for providing actual data.
How to use M code provided in a blank query:
1) In Power Query, select New Source, then Blank Query
2) On the Home ribbon, select "Advanced Editor" button
3) Remove everything you see, then paste the M code I've given you in that box.
4) Press Done
5) See this article if you need help using this M code in your model.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
// sample
let
Source = {0..100},
n = List.Count(Source),
gen = List.Generate(
()=>{0, {}},
each _{0}<=n,
each let Coarse=Number.IntegerDivide(_{0}, 10)+3
in if _{1}{3}? =null or _{1}{3}=9 then {_{0}+1, {0, _{0}, Coarse , 3}}
else {_{0}+1, {_{1}{0}+1, _{0}, Coarse, _{1}{3}+1}},
each List.Skip(_{1})
),
toTbl = Table.FromRows(List.Skip(gen), {"Index1", "Coarse", "Fine"})
in
toTbl
You see if I understand what you're saying, and if that's what you want, then I'll go ahead and write the whole thing.
What I'm trying to determine is how many times I need to repeat the same Coarse value, now I'm writing the code to repeat it 10 times, if the number of times the Coarse value needs to be repeated is variable, then under what conditions does it change?
Hi, @roncruiser
The complete code, I've changed it, you just need to follow the picture below to modify the parameters to achieve your desired effect.
// output
let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
chType = Table.TransformColumnTypes(Source,{{"Delay", type number}}),
fx = (tbl as table, Coarse_start as number, Fine_start as number, Fine_end as number)=>
let
sortedTbl = Table.Sort(tbl, {"Delay", 0}),
rows = List.Buffer(Table.ToRows(sortedTbl)),
n = List.Count(rows),
gen = List.Generate(
()=>{0, {}, 0},//{counter, {new_list}, delay_counter}
each _{0}<=n,
each let count = Fine_end+1-Fine_start,
Index1 = _{0},
Coarse = Number.IntegerDivide(_{0}, count)+Coarse_start,
Fine = Number.Mod(_{0}, count)+Fine_start
in {_{0}+1, {Index1, Coarse, Fine}, _{0}},
each List.InsertRange(rows{_{2}}, 4, _{1})
),
toTbl = Table.FromRows(
List.Skip(gen),
List.InsertRange(
Table.ColumnNames(sortedTbl),
4,
{"Index1", "Coarse", "Fine"}
)
)
in
toTbl,
group = Table.Group(chType, "Ref", {"t", each fx(_, 3, 4, 11)})[t],
result = Table.Combine(group)
in
result
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
