Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

Add a Calculated index column using DAX

Hello All, How can we create a index calculated column or measure using DAX, like we do in power query. Any help. Mohan V

General Comment

Interesting Links

Tips and Tricks

Tutorial Requests

v-huizhn-msft
8 years ago
Hi Anonymous,

What does your data source look like? I create the following sample table and get expected result.

sample table
I create measure using the formula below.

Index = RANKX(ALL(Test),FIRSTNONBLANK(Test[Project ID],Test[Project ID]),,ASC,Dense)

Then create a table, select the Project ID and measure as the value level, you will get expected result as follows.

Best Regards,
Angelia

Resolver IV

8 years ago

Anonymouswhat is the sort order of your table and does it has duplicate values in the sorted columns?

Anonymous

Not applicable

8 years ago

spuder it is ascending and no it dont have any duplicate values.

spuder
Resolver IV
8 years ago
Anonymous

then it should be working with RANKX()
- Anonymous
  Not applicable
  8 years ago
  spuder I just tried this.
  
  But i got the output which i am not expecting.
  I would like to get the no of rows that i will be having in that table dynamically,
  like in that above image i should get as 1
  2
  3
  4
  5
  Values.
  Any help
  - v-huizhn-msft
    Microsoft Employee
    8 years ago
    Hi Anonymous,
    
    What does your data source look like? I create the following sample table and get expected result.
    
    sample table
    I create measure using the formula below.
    
    Index = RANKX(ALL(Test),FIRSTNONBLANK(Test[Project ID],Test[Project ID]),,ASC,Dense)
    
    Then create a table, select the Project ID and measure as the value level, you will get expected result as follows.
    
    Best Regards,
    Angelia