Creating an Index Column for a Descriptive Data Using "DAX" in Power BI

Question

I have a table Like this,

Table1

ColA   ColB
Orange Apple
Mango  Not Apple
Mango  Not Apple

I want to create a column called as RowNumber using DAX and not Query Editor (M).

So the Expected output is,

ColA     ColB        RowNumber
Orange   Apple       1
Mango    Not Apple   2
Mango    Not Apple   3

This can be done in M - Power Query Side.

But, I am looking for a solution using DAX- Calculated Column.

I expected functions like RowNumber (T-SQL) or Index to be present inside DAX.

Nothing Specific. Everything like that is done on the Query Editor. But, if you need one - Take ColA — Student of the Digital World
– Student of the Digital World, Commented Mar 26, 2019 at 17:38

BenderIO · Accepted Answer · 2019-03-29 13:31:32Z

5

If you need to create an Index in DAX you can use this formula:

Index = RANKX(ALL(Barges),Barges[Date],,ASC)

RANKX: create your Index values

ALL: to avoid your Index to be partially generated if you have any filter

The second parameter is from where you want to sort your data, in my example I have an Index number increasing with an ascending order on my date, if I use Barges[name] instead for example I'll have my index generating with an A-Z sorting on my barges names.

answered Mar 29, 2019 at 13:31

BenderIO

4124 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Randy Minder Over a year ago

Excellent solution

Collectives™ on Stack Overflow

Creating an Index Column for a Descriptive Data Using "DAX" in Power BI

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related