Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
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.
your code looks very functional but now I would like to apply it to Oracle with power query
Thank you. I do not know how to do it in the Query Editor. May be someone else can help.
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |