Forum Discussion
Helper IIICopy 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 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.
s15 in power query just right click table and duplicate and remove columns you dont need
6 Replies
- fhill
Resident Rockstar
... 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
Community Champion
s15 in power query just right click table and duplicate and remove columns you dont need
