Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have an existing table that was created in Power BI by importing a massive CSV file. I want to create a new table in the query editor so I can pivot two columns, without altering the original data table
If I simply create a new table in DAX, it will not let me pivot the columns in the query editor
How can I simply create a new table in the query editor from an existing table, with several columns?
Original table: table1
Columns I want: rowID, status change date, process step
Solved! Go to Solution.
Hi @Anonymous ,
You can do the following:
You can then further use this new table reference to do your transformations.
Thanks,
Pragati
Duplicate the query create a new query that is identical in step an result to the one you copy from till the step you reached at the moment of copying.
If the original query from which you copied change the copied one won't.
Reference a query is like referencing a cell in excel. If the original query change, also the referenced one will.
Hi @Anonymous ,
Refrencing a table doesn't create a complete copy of the table from memory point of view and doen't take any extra power BI storage. Therefore it is always good to refrence a table rather than using Duplicate. So good to use the earlier option.
You can remove the columns which are not required.
Thanks,
Pragati
Hi @Anonymous ,
You can do the following:
You can then further use this new table reference to do your transformations.
Thanks,
Pragati
Thank you -- worked perfectly. How is referencing different than copying the table? or is it the same?
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |