Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Sagejah9
Helper III
Helper III

How to create an index column as a calculated column in dax

Hi. 
I have a one column table that I need to index starting from one in order to use it to sort in the visuals in the the reporting view. Any ideas? Only power query I see where that can be done. 

1 ACCEPTED SOLUTION
Mahesh0016
Super User
Super User

Mahesh0016_0-1670905726412.png

Hello @Sagejah9 ,
Good Morning

create calculated column using dax formula it is helpful for you. 

View solution in original post

5 REPLIES 5
Mahesh0016
Super User
Super User

Mahesh0016_0-1670905726412.png

Hello @Sagejah9 ,
Good Morning

create calculated column using dax formula it is helpful for you. 

Thanks @Mahesh0016 , although this ranks it based on alphabetical order, I want to keep the order in the data view and start the first row 1

Please give PBI file if you....

MahyarTF
Memorable Member
Memorable Member

Hi,

Not sure if it is useful for you, 

But if I usually use the Rankx function in Dax when I don't use Index via Power Query :

https://dax.guide/rankx/

Appreciate your Kudos and please mark it as a solution if it helps you.

Mahyartf

Thanks @MahyarTF 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.