+ Reply to Thread
Results 1 to 3 of 3

Power Query - Maxif Filter

  1. #1
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    365
    Posts
    236

    Power Query - Maxif Filter

    Hello,

    I'm trying to build a power query that sorts out duplicate values by the maximum in one column. I have duplicate values in column "WO #" and unique values in "Last seen on". I want to remove duplicate rows by column "WO #" and keep the maximum by column "Last seen on"
    I'm thinking a MAXIF that returns a true/false based on max range = "Last seen on" with a criteria range of "WO #" and criteria = "WO #" and then filter by true/false, but I cant seem to get the syntax right inside query editor.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,864

    Re: Power Query - Maxif Filter

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Power Query - Maxif Filter

    All you need to do is group using the max aggregate.

    Provide a workbook if you want this demonstrating.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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 M - Filter last two days
    By Saint_jordi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2021, 04:19 AM
  2. [SOLVED] Power Query Filter
    By Richard_BAC in forum Excel General
    Replies: 25
    Last Post: 08-11-2020, 01:55 PM
  3. [SOLVED] Power Query Filter Column
    By bfaws in forum Excel General
    Replies: 3
    Last Post: 02-26-2020, 11:09 AM
  4. [SOLVED] Power Query Filter by Date Parameter
    By tkrupka in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-16-2019, 10:08 AM
  5. If paramater in Power Query is blank do not filter
    By Harveyhirst1 in forum Excel General
    Replies: 3
    Last Post: 09-18-2018, 06:59 PM
  6. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  7. Power Query - Filter by Date
    By brent_milne in forum Excel General
    Replies: 0
    Last Post: 03-16-2017, 10:39 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