Forum Discussion
Power Query Add Step
Hi,
I am unable to work out in power query how to add a step to calculate Column "Time-Copy.1" to have a column produce the "Required Result.
Hope somebody can help
Regards
Colin
Time-Copy.1 Required Result
12:29 PM 0
null 0
1:02 PM 0
null 0
1:37 PM Top2-2
Top-2 Top2-2
2:12 PM 0
null 0
2:47 PM 0
null 0
3:23PM Top-2
Top-2 Top-2
4:02 PM Top-2
Top-2 Top-2
4:42 PM Top-2
null 0
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.
16 Replies
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.
- Hi
I have tried and tried even to the point of gettind a headache I an struggling to reproduce step 4 "Expand Added Index1"Colin970 Can you share a sample file via OneDrive or similar? Just remove anything confidential, as long as the structure/layout remains the same as your real file.
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.
