Forum Discussion

alevandenes's avatar
alevandenes
Helper IV
3 years ago
Solved

get end date from below row

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

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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. 

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.