Excel VBA Tools from Andrew
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: PowerPivot Sort Multiple Columns

  1. #1
    Board Regular
    Join Date
    Apr 2008
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default PowerPivot Sort Multiple Columns


    PowerPivot Sort Multiple Columns
    Hi

    Apologies if it is a stupid question, is there a way to sort two columns in PowerPivot ?

    For example, sort column 1 by High-Low, and then still preserving that sort, move to column 2 and sort that ?

    Column 1 could be customer number, and then column 2 Date, so all customer orders together and then in date order.

    As soon as I highlight two columns the Sort button disappears, and I want to add a formula to look at the time between orders, but obviously that relies on all customers being together and in date order.

    Thanks for your help
    Gavin

  2. #2
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,065
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: PowerPivot Sort Multiple Columns

    Are you talking about the power pivot window? If so, no. Power pivot is a database, not a spreadsheet - the order of the data in storage is not trackable or referanceable.
    Matt Allington is a professional Power BI consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia at https://exceleratorbi.com.au.
    Author of the books Learn to Write DAX and Supercharge Power BI
    What is Power BI?

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
  •  

 

DMCA.com