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?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Christianvs ,

 

//I am trying to add and index/rank row to a table and in order to not get duplicate index numbers
Greg's method addresses the index issue for calculated tables. Is the table you need to get the index column for a calculated table? If not, you can easily create this index column in Power Query Editor.

 

1. As per the above, the way I can think of is to create another calculated column, similar to:

Index = CALCULATE(COUNTROWS('Indexed Table'),FILTER(ALL('Indexed Table'),'Indexed Table'[Value]>=EARLIER('Indexed Table'[Value])))

2. You can rename the field [Value] after the new table is completed.

3. This requires that each line return a scalar or unique value. If satisfied, you can use RELATED (with entity relationship) or LOOKUPVALUE (without relationship) to get the value.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data