Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Dynamic ranking in date table

Hello everyone I have a date table with two columns, the record id and the date. There are no duplicate records. I want to create a new date ranking column, ordered from lowest to highest, that alwa...
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Thank you very much for the help, but the proposed approach gives error "The expression refers to several columns. You cannot convert multiple columns to a scalar value"

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Syndicate_Admin Which one? ADDCOLUMNS or the measures? The measures work in my PBIX file.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    The suggested measure does not work: "

    RKINGCOLUMN = ADDCOLUMNS('CALEN',"rkingnew2",RANKX('CALEN',[dates],,ASC))"
    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      3 years ago

      Syndicate_Admin

      That was for creating a Table (calculated table). These are the measure functions:

      Rank Measure Ascending = RANKX(ALLSELECTED('Table'),CALCULATE(MAX([fechas])),,ASC,Skip)

Rank Measure Descending = RANKX(ALLSELECTED('Table'),CALCULATE(MAX([fechas])),,DESC,Skip)
      • Syndicate_Admin's avatar
        Syndicate_Admin
        Administrator
        3 years ago

        Excuse me, I said measure and it was left to say calculated column. " Before I tried "Rank Measure Ascending = RANKX(ALLSELECTED('Table'),CALCULATE(MAX([dates])),,ASC,Skip)" and and it doesn't work