Group By but keep original query

IanR
Posts: 13
Joined: Wed Aug 09, 2017 11:30 pm

Group By but keep original query

Postby IanR » Tue Nov 21, 2017 10:20 pm

Hi,
I would like to use the Group By function to create a 'condensed' version of a query/table but I would like to keep the original version as well.
The table that I am working with comes from CRM and contains web page visits. It's a new table but I expect it to grow to several million rows over the next two years. I need to have a distilled version of the table that just has one record per contact per day but I want to use the distilled version to look into original table to access the multiple pages that will have been visited each day. I could import the table twice but as I know it's going to become very large I'd rather only do the import once. I'm very new to Power Query. As far as I can tell a Group By always replaces the original table with the grouped by version. I hope I'm wrong.

I have another question but I'll put that into a different topic.

Thanks

IanR
Posts: 13
Joined: Wed Aug 09, 2017 11:30 pm

Re: Group By but keep original query

Postby IanR » Wed Nov 22, 2017 12:58 am

I'm pretty sure that all I have to do is copy the query before applying the Group By.
Apologies for asking something so simple.


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 4 guests

cron