Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
Hello,
Can someone explain, why this does not work ;
= let alist =
{2,3,4,2,2,3,4,2,2,3,3,2,3,2,2,3,3,4,2,2,3,4}
in
List.Accumulate( alist, {} , (s,c)=> s & { List.Last(s)?? 0 + c } )
but this does, I presume order of operations, but I'd like a bit more help than that please,
let alist =
{2,3,4,2,2,3,4,2,2,3,3,2,3,2,2,3,3,4,2,2,3,4}
in
List.Accumulate( alist, {} , (s,c)=>
let x = List.Last(s) ?? 0
i n s & { x + c } )
Richard.
Solved! Go to Solution.
The operator ?? has the lowest precedence, so "List.Last(s) ?? 0 + c" is equivalent to "List.Last(s) ?? (0 + c)"
The operator ?? has the lowest precedence, so "List.Last(s) ?? 0 + c" is equivalent to "List.Last(s) ?? (0 + c)"
Thanks, I thought more complex ; re wrtoe to
= let alist = {2,3,2,3,2,3,3,3,2,3,3,4,2,2}
in
List.Accumulate( alist, {} , (s,c)=>
s & { ( List.Last(s)??0 ) + c } )
yes, pretty much. You need to protect the coalesce from the addition.
let
alist = {2, 3, 4, 2, 2, 3, 4, 2, 2, 3, 3, 2, 3, 2, 2, 3, 3, 4, 2, 2, 3, 4}
in
List.Accumulate(alist, {}, (s, c) => s & {(List.Last(s) ?? 0) + c})
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 13 | |
| 11 | |
| 10 | |
| 9 | |
| 6 |