Last seen: Jul 8, 2026
Can't explain it either. Sorry!
You can wrap the relevant parts of bonus calculation in the Number.Round function, like this: ( Number.Round ( PtsBehind[H2H Score]{[Index]+1}...
Please see attached! Most of the applied steps were done by just clicking in the user interface and I did not put any effort into making the code look...
May I assume that you are somewhat familiar with Power Query? Let's say you have a table with two columns "Contact" and "ID", you would first group...
Could it be that the 81.833 in fact is 81.8333333333333333333? 1.5% of the latter equals 1.22750, which would round to become 1.228. Not sure how accu...
Added a formula similar to PointsBehind for the Bonus. Tested it by hard-coding some H2H values, although they were overwritten upon refresh. But I di...
As a variant, I created a new smaller table (starting with a reference to the larger table) with just the Team, H2H Score and PointsBehind, and assumi...
You haven't really connected to files in a folder in the way it is meant to be. When you connect to a folder you should at some point expand the "bina...
But the green table in the file I uploaded was made in PQ
Not sure if this a very useful operation but taking your request literally, perhaps the attached file can help you on your way.
In F1, that would be: =BYROW(A1#,LAMBDA(a,SUM(a))) A1 contains your RANDARRAY function.
Inserted my code in your file and it seems to work fine. And it's all dynamic. If the web page contains 100 rows or perhaps only 50 rows next time, it...
Thanks! I'll get back to you later. On my way out now.
OK, please see my previous post. I believe it could work for you.
You write "until you see where it ends". What do you mean by that? How big is your table? But, perhaps the technique demonstrated in the attached f...