Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Experts,
I am having an issue with the below code, It lays around the : result = List.Generate(
() => [runningTotal, additionalValuesList, 0], I get a error message stating that i need a token']' but can not find a issue here.
Any help as always would be greatly appreciated
Kind Regards
RunningTotal AdditionalValues
4 | 0 |
-6 | 0 |
-16 | 4 |
-19 | 10 |
-21 | 6 |
-35 | 3 |
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
AddValues = Table.AddColumn(Source, "AdjustedRunningTotal", each
let
runningTotal = [RunningTotal],
additionalValuesList = List.Buffer(Table.Column(Source, "AdditionalValues")),
result = List.Generate(
() => [runningTotal, additionalValuesList, 0],
each List.First(_) < 0,
each [
List.First(_) + List.First(List.Middle(_)),
List.RemoveFirstN(List.Middle(_), 1),
List.Last(List.Middle(_)) + List.First(List.Middle(_))
]
)
in
List.First(result)
)
in
AddValues
Solved! Go to Solution.
Hi, @Stubrg [runningTotal, additionalValuesList, 0] is record, record has fields, fields have names. Your record does not have field names.
Next, each List.First(_) < 0 evaluates each item in the list that List.Generate generates. But wait, the very first item is record, not list.
And finally, even if you fix all bugs in your code then List.First(result) is going to give you ... the very first item which is your record defined in the very first line of List.Generate.
You'd better explain here how would you like the column AdjustedRunningTotal to be calculated.
Hi, @Stubrg [runningTotal, additionalValuesList, 0] is record, record has fields, fields have names. Your record does not have field names.
Next, each List.First(_) < 0 evaluates each item in the list that List.Generate generates. But wait, the very first item is record, not list.
And finally, even if you fix all bugs in your code then List.First(result) is going to give you ... the very first item which is your record defined in the very first line of List.Generate.
You'd better explain here how would you like the column AdjustedRunningTotal to be calculated.