Forum Discussion

s15's avatar
s15
Icon for Helper III rankHelper III
9 years ago
Solved

Copy two columns to a new table

Hi all,   I have a sample dataset like the one below     What I need is to create a new table then copy Sales and Years column to this table. The purpose is that I will need to pivot Years...
Need Help
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    s15 in power query just  right click table and duplicate and remove columns you dont need

fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
9 years ago

... I'm not sure if it's exactly what you are trying to do (of if you are trying to copy the two columns to a table that already has other data)???

 

But if not, you can Right Click and Dupliate the entire Table in PowerBI, then delete the rows you don't need for the Pivot?

 

FOrrest

  • s15's avatar
    s15
    Icon for Helper III rankHelper III
    9 years ago

    Currently I only have one table named financials. I need a new table names Sales where I need to duplicate data in Sales and Year column from financials table to Sales table.

     

    Could you point me to somewhere that I can use Duplicate table. This might be an option then delete uneccessary columns.

     

    Thank you very much.

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      9 years ago

      s15 in power query just  right click table and duplicate and remove columns you dont need

      • calerof's avatar
        calerof
        Icon for Impactful Individual rankImpactful Individual
        7 years ago

        Hi vanessafvg ,

         

        Question, when you duplicate a table, let's say a dim table, does it get updated every time the original dim table is modified?

         

        Thanks,

         

        Fernando