Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power Query - Loop calculating

Hi,   I have the following Excel table:   The column A and B are given data. The column A represents a duration of tasks in decimal format. And the column B represents the end date of the f...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    First, create a index column and this code for a custom column:

    let _b = #"Added Index"[B]{0} in
    List.Accumulate(
    List.Combine(
    {{_b},
    List.Range(#"Added Index"[A], 0, [Index] + 1)}),
    0, (s, c) => s + c)

     

     

    Change the bold part with your last step name.

vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
6 years ago

Hello Anonymous 

 

Is this the output you are looking for?

 

If yes, then you can use a custom column to add the values of the first two column.

 

If not, then please share more details.

 

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi vivran22 

 

This is not the output that I need. In this case, I don't have the list of end dates. I just have the end of the first row (the first task). And the next rows are sequential tasks.

Therefore, the second task will end with the following operation (end date of the first line + duration of the second task).

Anyway, the friend below presented the solution that I needed.

But thanks for the help !!

Best regards!