Forum Discussion
New table / query based on existing query
I believe a problem I'm having is very similar to that of the original poster, however the proposed solution does not quite solve my problem.
Let's say my original table is loaded into the Query Editor with columns: | ID | A | B | C | X | Y | Z |
I would like to create a 2nd table with only columns: | ID | X | Y | Z |
(perhaps by duplicating the entire 1st table and then deleting unnecessary columns | A | B | C | )
I would then like the 1st table to end up with only columns: | ID | A | B | C |
(i.e. simply deleting columns | X | Y | Z | ). Therein lies the problem: this deletion of columns in the 1st table must happen AFTER the 2nd table has been created.
Suggestions?
Yes, create a third query.
Additionally you may want to uncheck "Enable Load" for your first table that has all columns.
I believe you're recommending that I load the data twice from the source, and that is what I'm doing currently, but it's inefficient and undesirable due to the volume of data.
My ideal solution would involve loading the data once then duplicating within the Query Editor. :-)
Look into the create calculated tables: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-6-create-calculated-tables/
It looks like the functions being used are referred to as DAX functions. A quick google search for DAX functions brings you to Microsoft's library of DAX functions. I think you want a filter function like allexcept(): https://msdn.microsoft.com/en-us/library/ee634795.aspx
