Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
76 | |
66 | |
60 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |