Forum Discussion

Christianvs's avatar
Christianvs
Icon for Helper II rankHelper II
4 years ago
Solved

Sorting and adding columns

Hi   I am trying to add and index/rank row to a table and in order to not get duplicate index numbers I used the DAX writte by Greg_Deckler in this post https://community.powerbi.com/t5/Quick-Measu...
Need Help
  • HoangHugo's avatar
    HoangHugo
    4 years ago

    Hi

    Q1: GENERATESERIES will always return index column in Ascending (1 to ...), so you can create new column to RANKX your [Value] in descending.

    Q2: yes, you can change column name in your function like ADDCOLUMNS("your expected name",GENERATESERIES(..))
    Q3: Yes, you can. Can you show me detail of error?

HoangHugo's avatar
HoangHugo
Icon for Solution Specialist rankSolution Specialist
4 years ago

Hi

Q1: GENERATESERIES will always return index column in Ascending (1 to ...), so you can create new column to RANKX your [Value] in descending.

Q2: yes, you can change column name in your function like ADDCOLUMNS("your expected name",GENERATESERIES(..))
Q3: Yes, you can. Can you show me detail of error?

Christianvs's avatar
Christianvs
Icon for Helper II rankHelper II
4 years ago

Thanks for your replies HoangHugo and v-cgao-msft.

 

I got it working now 🙂