Select Next date in column

[Annemie19]

Hi There, 

I want to create a measure which gives the next date in the column for the entityID in that row. For instance, in the table below, I want a new column which, let's say entity ID 92 the date is 29/06/2021 then it needs to give the date 29/09/2021. 

[AntrikshSharma · Accepted solution]

@Annemie19  You can use this:

Column = 
VAR CurrentRowEntity = Anne[EntityID]
VAR CurrentRowDate = Anne[MeasurementDate]
VAR SameRows =
    FILTER (
        Anne,
        Anne[EntityID] = CurrentRowEntity
            && Anne[MeasurementDate] > CurrentRowDate
    )
VAR Result =
    MINX ( SameRows, Anne[MeasurementDate] )
RETURN
    IF ( Result = BLANK (), CurrentRowDate, Result )

[amitchandak]

@Annemie19 , try a new column like

minx(filter(table, [entityID] = earlier([entityID]) && [measuredate] >earlier([measuredate])),[measuredate])