Reformating a table by removing duplicate rows

[Yazid]

Dear,

Here is my issue, within my table, I have to calculate a cumulative sum over specific rows.

Actually, for each value project_Nbr, i have to take into account the corresponding amount.

However, this table has duplicate rows which complicate the calculation of the running sum over the rows.

See below a snap from Excel expliciting the matter:

Thanks in advance for your support.

[Ashish_Mathur]

Hi,

Do you have a Date column?  If yes, then it is easy enough to solve.

[Anonymous · Accepted solution]

Hi @Yazid ,

Below is my table:

You can remove the duplicate in the PowerQuery:

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.