Forum Discussion
Anonymous
2 years agoNot applicable
Index column in DAX
Hi, I am trying to add a index column to a calculated table, the index is just a count a of rows, I don't want to sort. I just want to star with 1 until the last row of my report.
Thanks
3 Replies
- Dangar332
Resident Rockstar
Hi, Anonymous
go to power query editor>choose your table in which you want to add index>go to add column section>click on index column>close & apply - AnonymousNot applicable
Hi, I can't do that becuase is a calculated table. It is not possible to use Power Query, that is why I need it in DAX
- AlexisOlson
Super User
Fairly recently, a DAX function called ROWNUMBER was added to Power BI.
https://learn.microsoft.com/en-us/dax/rownumber-function-dax
I think that should do the trick.