+ Reply to Thread
Results 1 to 3 of 3

Remove Unique rows in Power Query

  1. #1
    Registered User
    Join Date
    03-08-2016
    Location
    romania
    MS-Off Ver
    2010
    Posts
    3

    Angry Remove Unique rows in Power Query

    I have a table pulled from multiple csv files using Power Query.
    There are a few columns that matters: Date, Client ID, Status (Failed/Success)

    Basically I can see there how many times they failed to do something.

    I have 3 scenarios

    1. Failed
    2. Failed and succeeded after
    3. Succeeded without failing (this is what I don't need ant I want to filter out)

    I want to be able to see this by date.

    So I need to delete scenario 3 based on Date and CID (because during the month he can try multiple times).

    can I do it from power query so my final data table will not need any modifications?

  2. #2
    Registered User
    Join Date
    03-08-2016
    Location
    romania
    MS-Off Ver
    2010
    Posts
    3

    Re: Remove Unique rows in Power Query

    Formula is:
    =IF([@Status]="Success",SUMPRODUCT(--([@Date]&[@CID]=[Date]&[CID])),0)

  3. #3
    Registered User
    Join Date
    03-08-2016
    Location
    romania
    MS-Off Ver
    2010
    Posts
    3

    Re: Remove Unique rows in Power Query

    solution.PNG
    Formula is:
    =IF([@Status]="Success",SUMPRODUCT(--([@Date]&[@CID]=[Date]&[CID])),0)

+ 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. Replies: 2
    Last Post: 07-19-2015, 06:04 PM
  2. Remove unique rows from spreadsheet
    By a_bi in forum Excel General
    Replies: 2
    Last Post: 11-21-2014, 03:41 PM
  3. Macro to Remove Unique Rows.
    By 62deadfly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2011, 08:00 AM
  4. How to remove unique rows (macro)?
    By davidparkes in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-04-2011, 03:26 PM
  5. How to remove unique rows (macro)?
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-04-2011, 01:45 PM
  6. Remove unique rows and keep duplicates
    By tmduffy in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 10-30-2010, 08:31 AM

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