Row number in a visual table using DAX

Hi @Roberto

So you just need an index column so that the table visual will differentiate the records, it doesn’t have to hold any meaning?

You could add an index in PQ through Add Column → Index Column. Although I’m not sure if DQ will allow this.

If not, you can do it in SQL as @AntrikshSharma mentioned with something like this:

image

And then save that as a SQL view and use that for your datasource. You can tweak the ORDER BY clause to give it more logic if required but it sounds like it doesn’t matter to you what index is assigned to each record.

2 Likes