Results 1 to 8 of 8

Power query grouping - conditional to data across several columns??...

Threaded View

  1. #1
    Registered User
    Join Date
    03-27-2021
    Location
    Belgium
    MS-Off Ver
    365
    Posts
    4

    Question Power query grouping - conditional to data across several columns??...

    Hi
    I am rather new to power queries, and so far building my power pivot was going very well. Until I bumped into this -

    I have a list of orders with corresponding shipment data (3 columns). Shipment data is received from an external source. Every update will create a new line for the same order number.

    for example:

    Order.ItemID ETS ETA Vessel name
    8753060.11 4/21/2021 5/4/2021 MAERSK BULAN
    8753060.11 5/14/2021 6/6/2021 TBN

    Challenge is - I need only one line per order, with the latest update which in this case will be ETS ETA and Vessel name from the last row, i.e. latest ETS and ETA dates.
    I'm struggling to figure out how to achieve that.

    Would appreciate some help!
    Thanks
    sunnyspirit
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by sunnyspirit; 03-28-2021 at 07:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Power Query/Power Pivot Conditional Column creation & chart
    By mz_h in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-12-2020, 06:07 PM
  2. Data grouping in Power Query
    By hudson andrew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2020, 10:44 AM
  3. Replies: 10
    Last Post: 06-25-2020, 12:19 AM
  4. [SOLVED] Power query missed columns when import data
    By afgi in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 03-24-2020, 09:15 AM
  5. [SOLVED] Get and Transform (Power Query) - Grouping numbers into bands/buckets
    By TheNewUnion in forum Excel General
    Replies: 2
    Last Post: 03-12-2019, 05:37 AM
  6. Replies: 0
    Last Post: 10-25-2016, 02:59 AM
  7. Help with grouping in power query
    By stephme55 in forum Excel General
    Replies: 1
    Last Post: 07-26-2016, 03:09 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