Forum Discussion
Power Query Add Step
Colin970 See attached. Created the query in PQ for the Mac. It has a slightly different set-up. That's why the initial steps look a bit different. Didn't bother to re-write the M-code.
Colin970 At a first glance it seems that you want the time stamp to show Top-2 if the row below it has Top-2 in it. But that logic fails for the 4:42 PM at the bottom as it should have 0, not Top-2. So please clarify.
Colin970 See attached. Created the query in PQ for the Mac. It has a slightly different set-up. That's why the initial steps look a bit different. Didn't bother to re-write the M-code.
- Hi
Thats great do i add this to my sheetColin970 Are you asking how you should add this to my sheet?
I assume you are somewhat familiar with PQ. Then you should be able to follow the applied steps in my file and create similar ones in your own file. Perhaps you can just copy most of them over directly. I can't tell without seeing your file.