+ Reply to Thread
Results 1 to 2 of 2

Power Pivot return the TOPN'th value from selected column

  1. #1
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    MS Office 2010
    Posts
    213

    Question Power Pivot return the TOPN'th value from selected column

    Hi All,

    I am working inside Excel Power Pivot, so I am not looking for a PBIX solution.

    I have the following function established for my TOPN table:

    TOPN(1000,CALCULATETABLE(fData_Al_Time,fData_Al_Time[Week_Class]="PreviousWeek",fData_Al_Time[Calced_Ride_Class]="Successful"),[Dispatch time],1)

    I want to extract the TOPN'th value instead of performing any other aggregations, how can I do that.

    I tried to use MAXX, but its gives me the MAX number from the overall column, not the TOPN'th row:
    MAXX(TOPN(1000,CALCULATETABLE(fData_Al_Time,fData_Al_Time[Week_Class]="PreviousWeek",fData_Al_Time[Calced_Ride_Class]="Successful"),[Dispatch time],1),[Dispatch time])

    Any help is appreciated.

    Thanks in Advance.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    61,943

    Re: Power Pivot return the TOPN'th value from selected column

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


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


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite 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. [SOLVED] Power Query/Power Pivot Conditional Column creation & chart
    By mz_h in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-12-2020, 06:07 PM
  2. Replies: 3
    Last Post: 08-10-2020, 11:38 AM
  3. Replies: 4
    Last Post: 07-01-2020, 02:13 AM
  4. Pivot / Power Pivot - Year To Date Column
    By Ballet4ever in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 04-30-2019, 08:42 AM
  5. [SOLVED] Power Pivot does not load new column added in Power query
    By ibuhary in forum Excel General
    Replies: 12
    Last Post: 02-19-2019, 03:53 AM
  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. Return closest value less than given number matching another column - Power Query ?
    By ChipsSlave in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2017, 03:16 PM

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