+ Reply to Thread
Results 1 to 6 of 6

Filtering Earliest Date of Each Month

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    Bangkok
    MS-Off Ver
    Excel 2010
    Posts
    3

    Filtering Earliest Date of Each Month

    I was trying to do so in custom filter, for Earliest Date of Each Month even in the power query mode (Data Sources of Pivot table), still not be able to do so. Any suggestions?
    Last edited by mingmac; 03-18-2021 at 12:00 AM.

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

    Re: Filtering Earliest Date of Each Month

    Might be possible with Power Query, but......

    .....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
    Registered User
    Join Date
    01-09-2014
    Location
    Bangkok
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Filtering Earliest Date of Each Month

    Done Uploading. THanks.
    Attached Files Attached Files

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Filtering Earliest Date of Each Month

    Try to filter "TRUE" column E, with E3 is:

    =AGGREGATE(15,6,$C$3:C3/(TEXT($C$3:C3,"mm/yy")=TEXT(C3,"mm/yy")),1)=C3
    Attached Files Attached Files
    Quang PT

  5. #5
    Registered User
    Join Date
    01-09-2014
    Location
    Bangkok
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Filtering Earliest Date of Each Month

    Quote Originally Posted by bebo021999 View Post
    Try to filter "TRUE" column E, with E3 is:

    =AGGREGATE(15,6,$C$3:C3/(TEXT($C$3:C3,"mm/yy")=TEXT(C3,"mm/yy")),1)=C3
    That worked great.

    Also, do you have any ideas if I want to create custom column that contain TRUE and FALSE and Filter TRUE in Excel Power Query?
    Thanks.
    Last edited by mingmac; 03-18-2021 at 03:28 AM.

  6. #6
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Filtering Earliest Date of Each Month

    I have no idea about PQ.

+ 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. Formula to find the earliest date in excel base on a given date and text
    By Rikii Sumat in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-27-2017, 02:35 AM
  2. [SOLVED] Filtering date according to first day of each month
    By Hunbat in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-01-2017, 12:02 PM
  3. Replies: 3
    Last Post: 02-10-2016, 07:26 PM
  4. Using index and match to return a value based on earliest occurrence (MONTH)
    By potatoman in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-09-2014, 06:12 AM
  5. Using index and match to return a value based on earliest occurrence (MONTH)
    By potatoman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2014, 06:16 AM
  6. Excel find earliest date within 12 month period.
    By rkemplin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-18-2012, 09:13 PM
  7. Return the earliest day of a month
    By vickyho1008 in forum Excel General
    Replies: 1
    Last Post: 07-07-2008, 04:49 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