+ Reply to Thread
Results 1 to 4 of 4

Power Query list generate running total

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    608

    Power Query list generate running total

    Hi

    Workbook attached with both versions.

    can someone explain or point me in the direction of more information on using Records within list .gernerate;

    I have a running total


    Please Login or Register  to view this content.

    which works, but if I remove the [] from Count so { [Count] + 1} becomes { Count + } , it doesn't fail but I get the
    previous values + the next not the current value?


    Richard.
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Power Query list generate running total

    [Count] is equivalent to _[Count] so it's the value of the count field in the record passed into the function from the previous step.

    Count is the value of the count field in the record that will be returned from the function. Since you've specified that that will be [Count] + 1, if you use count + 1 it's the same as [Count] + 2
    Rory

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    608

    Re: Power Query list generate running total

    I shall have to think about that, I sort of understand, almost,

    thanks,

    RD

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Power Query list generate running total

    If it helps, that's why this would return an error:

    Please Login or Register  to view this content.
    because you'd be trying to assign a value to a field in the new record using the new record's field, which doesn't exist yet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Power Query Custom function for running total
    By Dicken in forum Office 365
    Replies: 6
    Last Post: 10-29-2022, 10:58 AM
  2. Power Bi running total controlled by slicer
    By Dicken in forum Office 365
    Replies: 1
    Last Post: 09-07-2022, 11:03 AM
  3. [SOLVED] Power Bi running total and power pivot
    By Dicken in forum Office 365
    Replies: 1
    Last Post: 07-08-2022, 02:15 PM
  4. Replies: 3
    Last Post: 02-25-2022, 06:33 AM
  5. [SOLVED] Running total in power query with criterion
    By Dicken in forum Office 365
    Replies: 6
    Last Post: 01-10-2022, 09:33 AM
  6. Power Query Grouped Running Total
    By sle7en in forum Excel General
    Replies: 2
    Last Post: 02-13-2021, 06:30 PM
  7. [SOLVED] Power Query - running from VBA
    By kemit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2018, 06:49 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1