Pivot table

[Anonymous]

I have this table on PowerBI which lists the budget and savings of 3 projects:

I tried unpivot on Project, Budget and total savings to get the following table (Removed the "savings" in order to get just the year) :

But what this does is counts the budget for a project multiple times (twice for A & C, thrice for B) on the sheets when i want to display the total project budget.

Is there a work-around for this? I want the total budget for a project only counted once, but savings to be in separate rows for each year.

Ideally i want something like this:

P.S.: I cannot devide the budget by number of years (all projects dont run for equal number of months/dates year over year).

[Ahmedx · Accepted solution]

pls try

[Anonymous]

Hi @Ahmedx,
Thanks for your reply. I tried your solution in my code and I got an Expression.SyntaxError: Invalid identifier error. I did exactly the same as yours, but I had 4 columns to summate instead of 2, so I changed that: 

I tried removing 2 columns out of the ReplaceValues exactly same as your code, but I still got the same error.
From the pointer shown in the error, it doesn't look like an error with the wording of the code.

Can you please help me figure out what is the mistake here?

Thanks

[Ahmedx]

you wrote the code incorrectly, please take a look at my code

[Anonymous]

I tried with just 1,1 as well. Doesn't seem to do the job.

[Ahmedx]

you write incorrectly give me your file I will help

[Ahmedx]

problem with the name give this column a normal name without ()

[Anonymous]

Yup. That's it 
Thanks!