Hello dear forum,
I am trying the following in PowerQuery: similar to MS Project, but in the simplest form.
There is a table with various tasks in a project. The table contains:
Task name
Task start date
Task duration in days
A sequence of tasks (1-n)
The end date of the first task is calculated as Start date 1 + Task duration 1 and becomes the start date of the second task. The end date of the second task (Start date 2 + Task duration 2) in turn serves as the start date of the third task, and so on.
Only the first task has a predefined start date (milestone).
I tried it with ChatGPT first , but the biggest nonsense came out. 😟
I am grateful for any help!
Helmut
Probably not very difficult, but to avoid that we are providing a solution that probably doesn't exactly fit your situation, please share a file that represents the table you are dealing with and indicate what result you would like to achieve.
@riny Hi
I have added the file to the original post
See attached. Perhaps a bit clunky but it works and it doesn't require any complex M-coding.
Would this work for you?
Hi, great job and pretty fast. It looks perfect
I will test and maybe have some additional modifications and questions.
Have a nice weekend
Thanx
Helmut