Forum Discussion
Help with extracting various time-based data
New to Power Query and would appreciate any help in how to attempt the following: Identify the data point that occurred at the closest time prior to the time of an event, within a window of time (i...
Thank so you such for taking the time! This is still better than my unexperienced attempt at it. Not surprised about data errors from that file. Definitely learned quite a bit from your example. It's too bad I can't make it do my calculations automatically but this still saves time.
Have a blessed day.
Have a blessed day.
yoonsp Not saying it can't be done in PQ, though I can't think of an easy way right now. Anyway, glad I could help a bit.