list.generate

  1. T

    Faster Alternative to Conditional Running Total than List.Sum

    Hello everyone, I'm trying to add a column that will sum up values in another column based on a few conditions. The code I currently have uses List.Sum. I have to do a similar conditional running total calculation several times in my query along with a few other transformations. The query...
    • takoyaki
    • Thread
    • conditional running total list list.generate list.sum power query running total
    • Replies: 9
    • Forum: Power Tools
  2. K

    Power Query - Function (Average Daily Balance) - Repeat for Each Dynamically Named Column and Dynamically Changing Number of Columns

    Hello, It has been a very long time since I have posted on here, so I apologize in advance if I am rusty on any preferred protocol and information/data to include on a post. I need to be able to able to obtain the average daily balance of each case, for each quarter. Since I have not found a...
    • KnightFhawker
    • Thread
    • average daily balance daily balance dynamic columns dynamic name dynamic number of columns excel function list.accumulate list.generate loop power query repeat running total
    • Replies: 7
    • Forum: Power Tools
  3. smozgur

    Translate to Multiple Languages with Power Query - Part 3

    In the previous article of this series, Power Query vs. Google Translation API - Part 2, we discussed how to make more effective Google Translation API calls by combining all rows as a whole text with a delimiter and send it to the web server in a single batch. In this last article of the...
    • smozgur
    • Excel Article
    • api list.generate list.insertrange power query text.fromcolumns translation
    • Category: Power Query
  4. smozgur

    Power Query List.Generate vs. VBA For...Next

    When I read Bill's "How Would You Clean This Data" challenge couple months ago, I thought that it could be easily done by using VBA. However, the article was all about Power Query. I was interested in learning the M language. I was even more interested in comparing VBA with M language. During...
    • smozgur
    • Excel Article
    • clean data for...next loops list.generate power query
    • Category: Power Query

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top