create new table from existing table column

[RAKESH1986]

Hi all,

pls, help me to solve this issue.

I have an existing table and from this table, I need to create a new table but need to sum of values in the new table.

I need a new table with three columns only

discipline, PW attribute, PW value

civil & structural , pw17, 0.45%

civil & structural , pw18, 0.46%

could you help me with how to do this?

thanks

[Greg_Deckler · Accepted solution]

@RAKESH1986 Right-click your query and create a reference. Select your three columns, right-click the header row and choose "Remove other columns". Now do a Group By operation, group by discipline and PW attribute with a sum aggregation for your PW value.

[RAKESH1986]

@Greg_Deckler  Thanks for response.

but this not working for me, see below

I added groups by two columns.

after this, I am getting the error invalid ref

what wrong I did in this step?

[apratt2003]

Is the data source an Excel file?  If so, there may be a reference error in one or more of the cells that Power Query can not handle.