Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: power query running total help
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2011
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default power query running total help

    I have a complicated windowed running total I'm trying to calculate. I've made an excel example that I'd like to implement in powerquery so I don' thave to copy the formulas down. Here's an example file
    https://file.io/k7yZ4D

  2. #2
    Board Regular
    Join Date
    Jul 2011
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: power query running total help

    https://file.io/ZUikzt
    Here's a better file

  3. #3
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,818
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: power query running total help

    expected result example?
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,818
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: power query running total help

    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  5. #5
    Board Regular
    Join Date
    Jul 2011
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: power query running total help

    The column on the right is the expected result. I implemented the expected result in excel, now I want to implement it in power query. Sorry that wasn't clear

  6. #6
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,818
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: power query running total help

    post #4
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  7. #7
    Board Regular
    Join Date
    Jul 2011
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: power query running total help

    Yes, post #4 says "or [try this link]" I was hoping for the "either" part not the "or" part as reading that link involves a level of power query mastering in includes creating a udf, passing the same table and other parameters, getting back a number. I presume it self casts to a primitive, hard to tell and then using that number. I don't know if this is all true, but looking at the amount of interest surrounding this topic, I guess this is an esoteric use case that isn't just easily implemented. Could be worse, could have to use a cursor or scala. Actually scala is easier.

  8. #8
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,818
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: power query running total help

    so I don't know what are you trying to achieve if that method from link is not acceptable for you

    besides hard to say something more if post#1 and 2:
    Last edited by sandy666; Aug 29th, 2019 at 10:21 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  9. #9
    Board Regular
    Join Date
    Jul 2011
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: power query running total help


  10. #10
    Board Regular
    Join Date
    Jul 2011
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: power query running total help

    I don't know how to add text to that prior picture, I'm trying to implement the "owe" column and you can see how the column was calculated.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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