locked
DAX RANKX - Cannot find in PowerPivot for Excel 2010 RRS feed

  • Question

  • Hi,

    Relatively new to PowerPivot so treat me as a rookie!

    I've been trying to use RANKX in PowerPivot for Excel 2010 but it does not appear to be available. I start typing RANKX but it does not appear on the function prompt list.

    Forum posts have suggested the need to install PowerPivot2 but whilst I cannot find any specific mention of version "2" I have downloaded and installed the current version of PowerPivot from MS but still no RANKX.

    What am I doing wrong?

    Thanks in advance.

    Matt

    Friday, January 15, 2016 10:54 AM

Answers

  • Hello Matt,

    I am using PowerPivot for Excel 2010 as well and RANKX function is available. Which version are you using; I have build 11.0.5058.0


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Michael Amadi Saturday, January 16, 2016 8:34 AM
    • Marked as answer by Charlie Liao Tuesday, January 26, 2016 9:30 AM
    Friday, January 15, 2016 11:13 AM
  • Hi,

    Thanks for such a quick reply. I have just this minute discovered MS offer both the original and version 2 for download from the MS site... Just downloaded the "other" version and now have RANKX!

    Thanks again.

    Matt

    • Proposed as answer by Michael Amadi Saturday, January 16, 2016 8:34 AM
    • Marked as answer by Charlie Liao Tuesday, January 26, 2016 9:29 AM
    Friday, January 15, 2016 11:39 AM

All replies

  • Hello Matt,

    I am using PowerPivot for Excel 2010 as well and RANKX function is available. Which version are you using; I have build 11.0.5058.0


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Michael Amadi Saturday, January 16, 2016 8:34 AM
    • Marked as answer by Charlie Liao Tuesday, January 26, 2016 9:30 AM
    Friday, January 15, 2016 11:13 AM
  • Hi,

    Thanks for such a quick reply. I have just this minute discovered MS offer both the original and version 2 for download from the MS site... Just downloaded the "other" version and now have RANKX!

    Thanks again.

    Matt

    • Proposed as answer by Michael Amadi Saturday, January 16, 2016 8:34 AM
    • Marked as answer by Charlie Liao Tuesday, January 26, 2016 9:29 AM
    Friday, January 15, 2016 11:39 AM
  • Hi,

    Glad to hear that your issue got solved. Please mark it as answer, it will helps others who have the similar issue.

    Thank you for your sharing.

    Regards,


    Charlie Liao
    TechNet Community Support

    Friday, January 15, 2016 2:04 PM