Calculate the running total for each row and populate with running total for each row separated by comma.
Of course, the query should be dynamic i.e. even if number of entries increase or decrease in a line OR/AND number of rows increase or decrease, the Query should give right result on Refresh.
Try to do maximum steps through UI and minimize formula / M-code.
The problem file related to this challenge can be downloaded from PQ_Challenge_8_Problem
The solution to this Running Total – Power Query Challenge 8 will be published after 2 weeks i.e. on Tuesday, 26-Mar-21. M
Hi
=TEXTJOIN("", "",,SCAN(,TEXTSPLIT(B2,"",""),LAMBDA(a,b,a+b)))
Excel 365 Beta
I’m impressed, I must say. Actually rarely do I encounter a blog that’s each educative and entertaining, and let me let you know, you will have hit the nail on the head. Your concept is excellent; the problem is something that not sufficient people are speaking intelligently about. I'm very pleased that I stumbled across this in my seek for one thing relating to this.
I really like your writing style, great info , thanks for putting up : D.