topic Select Next date in column in DAX Commands and Tips

Select Next date in column

Annemie19 — Tue, 01 Sep 2020 10:20:29 GMT

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.

Re: Select Next date in column

amitchandak — Tue, 01 Sep 2020 10:58:36 GMT

Annemie19 , try a new column like

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

Re: Select Next date in column

AntrikshSharma — Tue, 01 Sep 2020 12:49:35 GMT

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 )