Need Dynamic Aggregation

[jafernandezpuga]

Hi @praveer82,
Can you create an index for this table in the database to sort it based on the TIME field?
If you didn’t have duplicate values in the TIME field, we could determine which record is the previous one from DAX without using the index.

You could create it as @AntrikshSharma and @jamie.bryan comments in the next post.

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 i…

Greetings,