Forum Discussion
create new table from existing table column
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
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.
3 Replies
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.
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?
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.
