Power Query custom column is not capturing data

[sara1312]

HI below is the custom column code

But when mapped to a diffrerent file , all steps are working to capture the new data
Expect this step

How the source can be changed to previous step or latest mapped data

let
Source = Excel.CurrentWorkbook(){[Name="SCHEDULE"]}[Content],
Group = Table.Group(Source, {"Productionlinemap"}, {{"All", each
let
tbl = Table.AddIndexColumn(_, "idx"),
tbl1 = Table.AddColumn(tbl, "Threshold", each
if [Running Total] <= 36 then [Hours] else
if [idx] = 0 then 36 else
if tbl[Running Total]{[idx] -1} < 36 then 36 - tbl[Running Total]{[idx] -1} else
"Not Eligble"
)
in
tbl1
}}),
Result = Table.RemoveColumns(Table.Combine(Group[All]), {"idx"})
in
Result

 

[RoryA]

This appears to be related to this thread, so please stick to that. This thread is now closed.