Load extracted columns from query to new table

[dhankash]

I have a large table which has Complaints ID and Zip Code.  Zip code has recurring values because multiple complaints are received from the same zip code.  I ran a Query Editor to obtain distinct values of zip codes and the total # of complaints from each.  But when I close and apply, I think this new query goes back to the original table and messes up all the charts I have already built.  I need to load this query to a 'new' table so I can perform other tasks with it.  How can I do this?

Thanks,

[v-yuta-msft · Accepted solution]

Hi dhankash,

All the operation you have done in query editor will affect your report. Because data model(metadata) level will affect report level. So a simple solution to solve this problem is to duplicate a same "new" table in query editor and do operations on the duplicated table, then create visual based off the "new" table.

Regards,

Jimmy Tao

[dhankash]

Thank you.  This really worked.  However, I wish MS would provide an option to load new Queries to a new 'location' i.e. a new table if that is what the user wants to do. dk