Forum Discussion

RAKESH1986's avatar
RAKESH1986
Icon for Helper II rankHelper II
3 years ago
Solved

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 tabl...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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's avatar
RAKESH1986
Icon for Helper II rankHelper II
3 years ago

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's avatar
apratt2003
Frequent Visitor
3 years ago

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.