Forum Discussion
Picking out select data from a large table
Sam_S007 If you ar not into PowerQuery, perhaps you find the attached file useful. I inserted a few extra columns to create the chart data and a separate chart that looks like the one you provided. The selected data points are all that are closest to but not after, 20:45 on any given day.
Sam_S007 Far from beautiful and perhaps not very useful either. But then, I am a beginner in the field of PQ. As a long-term Mac user I only recently started using PQ after installing Excel for Windows, on a virtual W10 machine on my Mac.
Anyhow, as long as each file has a two structured tables, named Users and Prices, with headers exactly as in the attached file, the queries should create a table with dates for weekdays, user numbers closest to but not later than 20:45 and the closing price for that day. The graph is linked to the output table and should also update automatically. All can be refreshed at once but pressing the Refresh button on the Data ribbon.
Since you indicated that you downloaded the data from a service called RobinTrack, you probably need/want a more dynamic solution that allows you to directly query the website data, pulling in, transforming and refreshing data automatically. Doable, but as I'm not an expert in this field (yet) I don't consider myself the right person to help you with that.
Hi Riny_van_Eekelen,
This is fantastic! You just cut my workload by 99%. This is going to make a huge difference.
Thanks very much this is a superb template that will get a lot of use.
Sam
Sam_S007 Glad it worked out!