Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How do I use RANK() to rank date

Hi,    I am new to PowerBI!   What I have is the EQP_ID & FCST_TIME, and I would like to add a column  called "Rank' to display the FCST_OUT_TIME ranking by Measure Function The earliest FCST_OU...
  • Irwan's avatar
    Irwan
    2 years ago

    hello Anonymous 

     

    please check if this accomodate your need.

     

    create new calculated column with following DAX:

    Rank =
    var _Rank = 
    RANKX(
        FILTER(
            'Table',
            'Table'[FCST_OUT_TIME]
        ),
        'Table'[FCST_OUT_TIME],
        ,ASC
    )
    Return
    IF(
        ISBLANK('Table'[FCST_OUT_TIME]),
        0,
        _Rank
    )

     

    Hope this will help you.

    Thank you.

Irwan's avatar
Irwan
Super User
2 years ago

hello Anonymous 

 

please check if this accomodate your need.

 

create new calculated column with following DAX:

Rank =
var _Rank = 
RANKX(
    FILTER(
        'Table',
        'Table'[FCST_OUT_TIME]
    ),
    'Table'[FCST_OUT_TIME],
    ,ASC
)
Return
IF(
    ISBLANK('Table'[FCST_OUT_TIME]),
    0,
    _Rank
)

 

Hope this will help you.

Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Irwan The error is as above. How can I fix it? Thank you!

    • Irwan's avatar
      Irwan
      Super User
      2 years ago

      hello Anonymous 

       

      it couldnt find the column probably because the column name that i wrote is different from your column name.

       

      otherwise please check whether you use measure or calculated column.

      Jihwan_Kim 's solution is using measure while my solution is calculated column.

      That systax error is Jihwan_Kim 's solution.

       

      you are free to use either of them depend on your needs but please do take a note that writing DAX in calculated column and measure is slightly different.

       

      Hope this will help you.

      Thank you.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi, thanks for explanation. It works!