Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@s15 in power query just right click table and duplicate and remove columns you dont need
Proud to be a Super User!
... 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
Proud to give back to the community!
Thank You!
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.
@s15 in power query just right click table and duplicate and remove columns you dont need
Proud to be a Super User!
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
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.
Thank you for your kind response. Nobody bothered for almost 2 years.
Now I got it clearer.
Cheers,
Fernando
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |