Next date

[SErgey-kuznetso]

Hi, please help me with calculated column.

I have a column with the orders_id and dates sorted by ascending. I need to create another column with the dates but with the next date. Next, using the DATEDIFF function, I want to calculate the difference between these dates.

Example:

order_id	created_at	next_date
27512	08.10.2014 17:55:14	14.10.2014 0:46:32
27984	14.10.2014 0:46:32	14.10.2014 14:14:07
28036	14.10.2014 14:14:07	and so on
...	...	...

Screenshot:

[amitchandak]

@SErgey-kuznetso , Create a new column

Next Date = minx(filter(table,[created_at]>earlier([created_at])),[created_at])

[nandukrishnavs]

@SErgey-kuznetso 

Try this calculated column

next_date = MINX(FILTER(ALL('MyTable'[created_at]),'MyTable'[created_at]>EARLIEST('MyTable'[created_at])),'MyTable'[created_at])

 

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂