number each row

[Lu1sT0rr3s]

Hello All, 

I been trying to assign a number from 1 to the last row on each row on my table, I tried with Countrows but only gives me the total number of rows on each row.

There is a way to do what I need?

Thanks in advance

This is the column that I createdThis is the result, however what I need is that each row contain the number of row that is, from 1 to the end of the table

[AlB · Accepted solution]

Hi @Lu1sT0rr3s 

You can do this very easily in the query editor:  Add Column-> Index column

If you want to do it in DAX you need to have a way to establish an order  between rows  and I do not see it from the data you are showing

Please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. A screen cap doesn't allow people to readily copy the data and run a quick test and thus decreases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).

[Lu1sT0rr3s]

Thanks @AlB it works very well.

I will keep present your advice, I'm new using the application and there is a lot of things that I still dont know.