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:  th...
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. 

     

     

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.