Forum Discussion
Solved
Select Next date in column
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.
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 )
2 Replies
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 )Annemie19 , try a new column like
minx(filter(table, [entityID] = earlier([entityID]) && [measuredate] >earlier([measuredate])),[measuredate])
