Create end date from the start date and duration of an event

[Syndicate_Admin]

I need to calculate the end date of a table to be the start date of the next record and be able to graph in an example gant

[Syndicate_Admin]

Thanks I will try the truth is that my data source is oracle but thanks for your contribution I verify it and share if I get

[Ashish_Mathur]

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Product", type text}, {"Start date_time", type datetime}}),
    #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 0, 1, Int64.Type),
    #"Added Custom" = Table.AddColumn(#"Added Index", "Custom", each try List.Sum(List.Range(#"Added Index"[Start date_time],[Index]+1,1)) otherwise 0)
in
    #"Added Custom"

Hope this helps.

[Syndicate_Admin]

your code looks very functional but now I would like to apply it to Oracle with power query

[Ashish_Mathur]

Thank you.  I do not know how to do it in the Query Editor.  May be someone else can help.