Copy two columns to a new table

[s15]

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 column without making any change in the existing table.

What is the common DAX to use for this case? I read over the Internet and some guides suggesting to use caculated column and distinct function but I cannot seem to make it work.

[fhill]

... 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]

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 · Accepted solution]

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

[calerof]

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

[RodrigoMachado]

Hi @calerof  yes, when you duplicate a table its source remains the same, so when you edit your database your duplicated table will be edited as well.

[calerof]

@RodrigoMachado ,

Thank you for your kind response. Nobody bothered for almost 2 years. 

Now I got it clearer.

Cheers,

Fernando