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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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.