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.
2 posts • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 4 guests