Forum Discussion

Charline_74's avatar
Charline_74
Icon for Resolver I rankResolver I
2 years ago
Solved

Having an index column in a visual table

Hi On my Power BI report, I have a visual table that fetches columns from several tables. And I'd like to create an index in this visual but I don't know how to do it? Does anyone have a solution?...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    Charline_74 , You can create a column or measure using RANKX function

     

    For calculated column

    Index = RANKX(ALL('Sales'), 'Sales'[OrderDate], , ASC, DENSE)

     

    For measure

    IndexMeasure =
    VAR CurrentRow = MAX('Sales'[OrderDate])
    RETURN
    RANKX(ALL('Sales'), 'Sales'[OrderDate], CurrentRow, ASC, DENSE)

     

manvishah17's avatar
manvishah17
Icon for Solution Supplier rankSolution Supplier
2 years ago

Hi Charline_74 ,
Using Power Query Editor:

  1. Open Power Query Editor: Go to Home > Transform data.
  2. Add Index Column: Select the table, then Add Column > Index Column > Choose From 0 or From 1.
  3. Apply Changes: Click Close & Apply.
  4. Use Index: Drag the index column into your visual table.

Using DAX:

  1. Create Calculated Column: Go to Modeling > New Column, and use:
    Index = RANKX(ALL('YourTable'), 'YourTable'[ColumnToOrderBy], , ASC, Dense)
  2. Use Index: Add the new index column to your visual table.