+ Reply to Thread
Results 1 to 1 of 1

Power Query M add previous value column to grouped data

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

    Power Query M add previous value column to grouped data

    Hi,
    I've been trying to add a column to grouped 'all rows' which give previous row value;

    I have this working in non group ;

    Please Login or Register  to view this content.
    But I thought it might be easier to group by iitem and do the same for each group;

    Please Login or Register  to view this content.
    and then tried to build on that,

    Please Login or Register  to view this content.
    I've managed to make a function and invoke on the grouped date shown in attachment,

    Richard
    Attached Files Attached Files
    Last edited by Dicken; 07-06-2023 at 03:04 PM. Reason: More information

+ 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 previous non consecutive date
    By Dicken in forum Office 365
    Replies: 0
    Last Post: 05-28-2023, 05:55 AM
  2. Power Query previous Value of grouped data
    By Dicken in forum Office 365
    Replies: 0
    Last Post: 03-10-2023, 12:05 PM
  3. Power Query Sum within grouped data
    By Dicken in forum Office 365
    Replies: 5
    Last Post: 02-20-2023, 08:32 AM
  4. Replies: 0
    Last Post: 12-23-2022, 09:50 AM
  5. Power query Previous and current values
    By Dicken in forum Office 365
    Replies: 4
    Last Post: 12-14-2022, 12:09 PM
  6. [SOLVED] Power query return total value of grouped columns
    By Dicken in forum Office 365
    Replies: 2
    Last Post: 06-20-2022, 05:30 AM
  7. Power Query Grouped Running Total
    By sle7en in forum Excel General
    Replies: 2
    Last Post: 02-13-2021, 06:30 PM

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