DAX Record revisions column

[chris_k]

Hello,

I am trying to create a column to record revisions to a record. A bit like a more advanced "IsLatest" column.

Input table: 

RecordID Name Modified

ABC123	Testing	03/05/2019
ABC123	TestingMoreDetail	01/08/2019
ABC123	OkNotTestingNow	06/08/2019

Desired output table:

RecordID Name Modified Revision

ABC123	Testing	03/05/2019	1
ABC123	TestingMoreDetail	01/08/2019	2
ABC123	OkNotTestingNow	06/08/2019	3

I have two functions that get me the Latest revision and the second latest but need more than this...

Thanks,

[Stachu]

try this code

Column = 
VAR __RecordId = 'Table'[RecordID]
VAR __Modified = 'Table'[Modified]
VAR __RelevantRows = FILTER(ALL('Table'), 'Table'[RecordID] = __RecordId)
RETURN
RANKX(__RelevantRows, [Modified], __Modified, ASC)

it ranks the dates for a given RecordID