get end date from below row

[alevandenes]

Hi Community,

this is my current dataset in PowerBI

could you help me write a formula that takes the next row time to use as a end date?

it should look like this eventually: 

thanks a lot in advance for all the help

Kind regards

[raimon · Accepted solution]

Hi @alevandenes,

You can achieve this by adding an index colum thru power query first. 

Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type)

Then create a calculated column - 

If you dont see the result as above, ensure you have the right data type selected.