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.
I have a Table as below
this table has some items and quantity and price columns
what I want to do is divide these items to groups where the total sum of net price for each group does not exceed 2000$ ?
you can try this code, but the efficiency is a problem
NewStep=let a=Table.AddIndexColumn(PreviousStepName,"idx"),b=List.Buffer(a[Net Value]) in Table.Group(a,"idx",{"n",each _},0,(x,y)=>Byte.From(List.Sum(List.Range(b,x,y-x+1))>=2000))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
84 | |
77 |