Forum Discussion

Copper Contributor

Oct 28, 2022

Solved

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 ...

Riny_van_Eekelen
Oct 28, 2022
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.xlsx19 KB

Riny_van_Eekelen

Platinum Contributor

Oct 28, 2022

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
Copper Contributor
Oct 29, 2022
Hi

I have tried and tried even to the point of gettind a headache I an struggling to reproduce step 4 "Expand Added Index1"
- Riny_van_Eekelen
  Platinum Contributor
  Oct 29, 2022
  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
    Copper Contributor
    Oct 29, 2022
    Hi
    
    See link thers is no sensative information. Excuse my attemps to consoliate, if its too hard or you do not have time I understand. Thanks again
    
    https://1drv.ms/u/s!AuL2hHx5FRiPib1SSjtT7GQiVgGyNg?e=Ubt3Tz
Colin970
Copper Contributor
Oct 28, 2022
Riny_van_Eekelen

Hi, you are correct the 4:42PM should be zero

Colin
- Riny_van_Eekelen
  Platinum Contributor
  Oct 28, 2022
  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.xlsx19 KB
  - Colin970
    Copper Contributor
    Oct 28, 2022
    Hi
    
    Thats great do i add this to my sheet

Resources