treating dates as dates in pivot table
Results 1 to 4 of 4

Thread: treating dates as dates in pivot table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2011
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default treating dates as dates in pivot table

    https://snag.gy/QFOWNd.jpg

    Here I have a date column which is a date format in power query. There are no nulls or non date values. How do i filter this with the traditional date hierarchy or the option to select all dates after a date. It's random when excel deigns the data unworthy of special date handling.

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,585
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Default Re: treating dates as dates in pivot table

    sort date column in PQ
    filter date column in PQ as you wish

    edit:
    the best way is: post a link to the shared excel file with your whole example
    Last edited by sandy666; Aug 7th, 2019 at 09:21 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    Board Regular
    Join Date
    Jul 2011
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: treating dates as dates in pivot table

    I don’t understand. There is no column pq. I just mean in general when you have a date comping in power query or pivot tables it is arbitrary whether excel will let you treat it as a date that you can select and filter in a hierarchal manner or if they’re treated as a flat list of text you can’t even filter with a math function.

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,585
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Default Re: treating dates as dates in pivot table

    PQ == Power Query
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •